4,707 questions
SQL Server is a server to manage data, not to monitor OS or hardware.
Implement a monitor by installing a monitoring software, e.g. Windows PerfMon or some open source software like Nagios.
Cpu information using DMVs SQL Server
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 57.99999999999999%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Miiimy7
41
Reputation points
Hello guys!
i want to retrieve information about CPU (%processor time, ...) by using DMVs. I already know about sys.dm_os_ring_buffers but the interval during which informations are collected is pretty long (1 min) . Anything can happen in one minute!
If you have some tips, it would be cool!
Thank you very much
Developer technologies Transact-SQL
SQL Server Other
14,494 questions
3 answers
Sort by: Most helpful
-
Olaf Helper 47,436 Reputation points2021-04-14T06:00:00.89+00:00 -
Miiimy7 41 Reputation points
2021-04-14T07:15:29.923+00:00 hello,
yes but i just want the information about SQL Server. The CPU utilization used by the process in SQL Server.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Tom Phillips 17,771 Reputation points2021-04-14T18:54:23.263+00:00 That information is better monitored outside of SQL Server. Any perfmon monitoring will expose that information.
SQL Server is rarely CPU dependent. Are you having an actual problem, or just looking for hardware monitoring?
-
Miiimy7 41 Reputation points
2021-04-15T08:27:46.53+00:00 No i don't have any problem, i just want another monitoring solution instead of perfmon. I'm staying inside SQL Server concept. I want to retrieve all information about SQL Server within SQL Server only. And for that i'm playing with DMVs. But there are so many. And i'm asking here to get some tips.
thank you -
Tom Phillips 17,771 Reputation points
2021-04-15T15:10:41.273+00:00 I suggest you start here;
https://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2021-04-15T21:15:27+00:00 It that is what you are looking for, you can look at sys.dm_os_performance_counters.
Sign in to comment -
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
2021-04-14T21:19:57.943+00:00 Have a lot at the system function @@CPU_BUSY. This is a very ancient one, and you will have to read up a little on it to make sense out of it.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT 6,661 Reputation points2021-04-15T06:58:02.733+00:00 Hi,
If you need to monitor the resource usage of SQL Server in real time, it is more convenient to use tools from outside of SQL Server.
Using the performance dashboard (reports) in SSMS, and the DMVs of SQL Server itself, you can better understand the performance of SQL Server over a period of time.
-
Miiimy7 41 Reputation points
2021-04-15T08:30:02.21+00:00 Yes thank you but is there any possibilities that we can retrieve
data from Activity monitor in SSMS? -
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
2021-04-15T21:16:36.903+00:00 Yes thank you but is there any possibilities that we can retrieve
data from Activity monitor in SSMS?
By running queries? Sure. Activity Monitor is running queries for you, but you can use Profiler to find out what it is emitting.
-
Cris Zhan-MSFT 6,661 Reputation points
2021-04-16T03:49:42.1+00:00 Activity Monitor runs queries on the monitored instance to obtain information for the Activity Monitor display panes. When the refresh interval is set to less than 10 seconds, the time that is used to run these queries can affect server performance
Sign in to comment -