Query to Check

Question

Query to Check

RGP

SSCarpal Tunnel

Points: 4381
More actions
January 7, 2019 at 12:29 pm

#382554

Hi, I was hoping to get a query that will show me CPU, memory used, and Disk IO for SQL Server( not SP_WHO2)
And a separate query to get blockings on SQL Server. thanks

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

goher2000 SSCertifiable Points: 5479 More actions · Answer 1

SELECT [object_name]
  ,[counter_name]
  ,[instance_name]
  ,[cntr_value]
  ,[cntr_type]
FROM [master].[sys].[dm_os_performance_counters]

Sue_H SSC Guru Points: 90860 More actions · Answer 2

RGP - Monday, January 7, 2019 12:29 PM
Hi, I was hoping to get a query that will show me CPU, memory used, and Disk IO for SQL Server( not SP_WHO2)
And a separate query to get blockings on SQL Server. thanks

If you download Glenn Berry's diagnostic scripts, there are queries for all of those, including blocking:
SQL Server Diagnostic Information Queries for December 2018

Sue

RGP SSCarpal Tunnel Points: 4381 More actions · Answer 3

Thanks guys, I was looking for a single query that will give me CPU, IO and memory displayed for the sql instance (just an overview)
Something like this:

CPU	IO	Memory
2%	5%	5%

Jonathan AC Roberts SSCoach Points: 18257 More actions · Answer 4

RGP - Monday, January 7, 2019 1:13 PM
Thanks guys, I was looking for a single query that will give me CPU, IO and memory displayed for the sql instance (just an overview)
Something like this:
CPU IO Memory
2% 5% 5%

I think Perfmon is the tool for this.

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 5

Jonathan AC Roberts - Tuesday, January 8, 2019 3:43 AM
RGP - Monday, January 7, 2019 1:13 PM
Thanks guys, I was looking for a single query that will give me CPU, IO and memory displayed for the sql instance (just an overview)
Something like this:
CPU IO Memory
2% 5% 5%
I think Perfmon is the tool for this.

+100. Add the needed counters in perfmon and schedule it some days. Can you take a look later can can correlate.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

RGP SSCarpal Tunnel Points: 4381 More actions · Answer 6

muthukkumaran Kaliyamoorthy - Tuesday, January 8, 2019 5:26 AM
Jonathan AC Roberts - Tuesday, January 8, 2019 3:43 AM
RGP - Monday, January 7, 2019 1:13 PM
Thanks guys, I was looking for a single query that will give me CPU, IO and memory displayed for the sql instance (just an overview)
Something like this:
CPU IO Memory
2% 5% 5%
I think Perfmon is the tool for this.
+100. Add the needed counters in perfmon and schedule it some days. Can you take a look later can can correlate.

thanks

RGP SSCarpal Tunnel Points: 4381 More actions · Answer 7

Sue_H - Monday, January 7, 2019 12:56 PM
RGP - Monday, January 7, 2019 12:29 PM
Hi, I was hoping to get a query that will show me CPU, memory used, and Disk IO for SQL Server( not SP_WHO2)
And a separate query to get blockings on SQL Server. thanks
If you download Glenn Berry's diagnostic scripts, there are queries for all of those, including blocking:
SQL Server Diagnostic Information Queries for December 2018
Sue

thanks