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

CPU data used by the application databases Expand / Collapse
Author
Message
Posted Thursday, June 26, 2008 10:48 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, September 12, 2009 9:12 PM
Points: 65, Visits: 224
Hi,

I would like to know how to find out the CPU data used by the application databases
in SQl server 2005,Is there any query to find out exact usage of CPU

and also the growth of the CPU usage in a regular interwal

Regards,
Shine

Post #524757
Posted Friday, June 27, 2008 12:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 17, 2011 9:15 AM
Points: 44, Visits: 3,626
There are many methods you can achive this.

1) Go to run, type "perfmon". Add counter for CPU. This will give a graphical representaion of load on CPU.

2) If you want to check load of specific query on server, you can use profiler and check the CPU column.

3) You can also use DBCC SQLperf


HTH

sachin



Post #524785
Posted Friday, June 27, 2008 6:19 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, September 12, 2009 9:12 PM
Points: 65, Visits: 224
Hi,
I have around 30 dbs i need to store the details in one table and to monitor?
its liek collecting information about Cpu usage,

could you suggest some queries

smm
Post #524912
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse