Slow

Last Post 04 Feb 2010 04:30 PM by J013-B. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sql-tips
New Member
New Member

--
04 Feb 2010 01:53 PM
Very frequently we get a complains of slowness of the system. I verified sp_who2 and see the process and sp_lock to any blocks. other than that is anything from database point of view we should verify. Any reports to generate? any info will be helpful.
J013-B
New Member
New Member

--
04 Feb 2010 04:30 PM
You could check System Monitor and look at system resources such as CPU, memory, disk and network utilization as well as the SQL counters and see if there is a lot of activity.
You are not authorized to post a reply.

Acceptable Use Policy