Browse by Tags

• application
• blocking
• disks
• high cpu
• i/o
• object
• oltp
• performance
• query
• queue
• security
• server
• sql server
• stats
• table
• tuning
• type

Performance - check whether it is affecting application or system, don't blame SQL Server alone
03 September 07 07:42 AM | SQL Master | 2 Comments   

Its a general assumption that whenever performance is degraded, the finger will be pointed to SQL Server, pretty easy eh!? If you look at any of the SQL Server related forums then 3 in 10 questions asks same question and nothing but shove blame on SQL Read More...

Filed under: performance, sql server, security, query, wait, blocking, table, application, oltp, high cpu, queue

ASYNC_NETWORK_IO: query is slow
29 August 07 03:00 AM | SQL Master | 2 Comments   

When you run normal SELECT statement from the Activity Monitor, the session has a status of "suspended", a command of "SELECT" and a wait type of "ASYNC_NETWORK_IO". What do you expect to the see the results and within the column status, we will see quite Read More...

Filed under: tuning, performance, sql server, wait, object, i/o, disks, type

High CPU spikes affecting performance
26 April 07 01:59 PM | SQL Master | 2 Comments   

I have seen a common question across the forums & newsgroups that CPU is 100% when we are running a query on SQL Server. So it is important to understand whether CPU is affecting or is it a bad query that is affecting SQL Server performance in spite Read More...

Filed under: performance, sql server, security, server, stats, wait