Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

server performance. Expand / Collapse
Author
Message
Posted Tuesday, July 22, 2008 3:31 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 25, 2012 5:03 AM
Points: 71, Visits: 102


my server is running very slow.what should be the accurate way of trouble shooting it .provide the step by step very clear procedure

:P
Post #538288
Posted Tuesday, July 22, 2008 3:03 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 12, 2014 1:55 PM
Points: 149, Visits: 1,030
Here is what I do

1) Open SQL Profiler
2) Determine the counters that you need
**In my case I usually start with a blank template and add what I need to look at. If you are looking for query issues watch T-SQL: Statement
Completed and Stored Procedures: SP Completed. I use these because they both will show the full statement that is executed.
3) I set the Column filters so that I only see the Database I want to watch for performance by limiting it to a specific database ID
SELECT DBID FROM SYS.SYSDATABASES WHERE NAME = ' 

4) I set the column filters to watch for long running SQL Statements. This is done by setting the Duration setting to greater than or equal to 500
milliseconds. This may or may not be long enough for your Database, but the idea is to limit the number of returns that you see.

This will at least provide you a picture of what is going on in the Database. After that, you'll need to look at physical Server performance like disk queuing and memory swapping. However, that is OS level type stuff that indicates different issues.


Regards,

Irish
Post #538861
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse