Online Mind Mapping and Brainstorming

Create your own awesome maps

Online Mind Mapping and Brainstorming

Even on the go

with our free apps for iPhone, iPad and Android

Get Started

Already have an account? Log In

Website Problem by Mind Map: Website Problem
0.0 stars - 0 reviews range from 0 to 5

Website Problem

Site slow

Check Web server

CPU > 80%, w3wp.exe is taking high CPU, Check IIS log for long running pages, Run this query in Log Parser: SELECT TOP 25 cs-uri-stem as URL, MAX(time-taken) As Max, MIN(time-taken) As Min, Avg(time-taken) As Average, Count(*) As Hits FROM '[LOGFILEPATH]' WHERE URL LIKE '%.aspx' GROUP BY URL ORDER By Average DESC, If you have pages that is hit frequently (high Hits) and also > 10 Average, then those pages are likely cause., If no page is taking > 10 Average, then look for page that has very high Hit, may be in several thousands per minute. Those are your likely culprit, Some other process is taking high CPU, SQL Server and IIS on same box, You have made a fundamental design mistake. SQL Server and IIS must not run on the box., Some other app is taking CPU, Uninstall it! Why on earth is another app running on your web server?

High Memory Usage, Certain .NET Process is consuming high memory, If Virtual Memory significantly high compared to Working Set?, You are most likely using XmlSerializer with double or more constructor. Use single contructor., Non .NET process consuming high memory, Find out who is the vendor and ask for suport

High Disk usage, Counter: Memory: Pages/Sec > 0, Check from task bar which process is taking most RAM, All w3wp.exe process combined taking most RAM, You have run out of RAM. Add more RAM to your server or try to take some websites out of that box to somewhere else., Some other process taking most RAM, You should not have anything but IIS running on webserver., Is Page file size is smaller than 1.5 times the RAM? Then set it 1.5 times the RAM

Counter: Requests in Application Queue > 0

Counter: Request Execution Time is > 20 sec, You have some very slow pages or webservices that are consuming threads., Increase threads in processModel in machine.config if CPU consumption is low., If CPU consumption is high, then fix the code or get more servers and scale out

Check Database Server

Counter: SQL Server: Locks: Lock Timeout/Sec > 0, See Standard Reports: Top Transactions By Transaction Locks Count. Find the transaction that's blocking most of the transactions. Analyze the query and see why it takes so long.

Counter: SQL Server: Access Methods: Full Scans/Sec > 100, Bad queries, not hitting index. Find them from Standard Reports: Top Transactions by Average IO.

Counter: SQL Server: Access Methods: Table Lock Escalation/Sec > 20, Bad Queries, trying to read large amount of data and missing index. See from Standard Reports: Top Transactions by Average IO.

SQL Server: Memory Manager: Target Server Memory > Total Server Memory, SQL Server needs more RAM. Add more RAM

SQL Server: Buffer Manager: Buffer Cache hit ratio < 85%, SQL Server needs more RAM. Add more RAM, You have queries that's reading data from random distant places from the database and SQL server has no clue what to cache

Memory: Pages/Sec > 4, You need to have at 40% RAM of the total database size. If your database size is 10 GB, have 4 GB RAM given to SQL Server, You have some other process running on database server that's taking RAM. Find such process and uninstall them.

Processor: % Processor Time > 70%, You have queries that's CPU intensive.

Check Firewall and Load Balancer

Site down

Check Web server

CPU over 90%

Check IIS, Website stopped, Starting Web site fails to start, Check event log, Error: Another site is listening to the same port, Some new website was added which conflicts with an existing website host header and port. Fix it!, App Pool is crashing down, Restart IIS and see if it gets resolved, otherwise restart PC, Some other weird error, Contact Microsoft Support, Application Pool Disabled, Check Error in Event Log entries in System Category, Error: Too many unhandled exceptions, Bug in code, fix it!, Implement custom error handler, Error: Worker process terminated unexpectedly, Leak in code, fix it!, Memory Leak in code. Free memory., Resource leak in code. Use Dispose properly, I/O operations failing frequently eg file access fails too frequently, Exceptions raised from background thread not being handled via try catch:, Not enough RAM, Error: Worker process was stopped due to Health Monitor, IIS Stopped, Start IIS fails, Restart PC does not fix the problem, Check Event Log Entry, Out of disk space

Check ASP.NET Performance Counters, Error: Too many unhandled exceptions, Bug in code, fix it!, Implement custom error handler, Too many Application Restarts, Exception being thrown from background thread., High number of Requests in Application Queue, Outbound calls are taking too long to finish. Lower down timeout or implement async pattern:, Database calls are taking too long to complete. Optimize queries to execute faster.

Check Database Server

SQL Server service stopped

Database offline

SQL Server connection failing

SQL Server not executing query

Check Firewall and Load Balancer

Site sometimes comes

Check Web Server

High CPU

Check ASP.NET Perf Counters

Check Database Server

Check Firewall and Load Balancer

Randomly Requests fail