CPU data used by the application databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » CPU data used by the application databases

CPU data used by the application databases

Rate Topic

Display Mode

Topic Options

Author

Message

sps-554505

Posted Thursday, June 26, 2008 10:48 PM

Valued 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

sachinsamuel1

Posted Friday, June 27, 2008 12:33 AM

SSC 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

sps-554505

Posted Friday, June 27, 2008 6:19 AM

Valued 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 »

Permissions