<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
CPU
Items 1 to 5 of 5
Top 14 KPI
Get the 14 most used Key Performance Indicators
Read more...
By
Monte Kottman
2012/11/09
|
Source:
SQLServerCentral.com
|
Category:
kpi
Rating:
|
Discuss
|
Briefcase
|
2,109 reads
How to Monitor for High CPU utilization in SQL Server
This is the method that Geoff Albin has used for years to monitor the CPU on his SQL Servers.
Read more...
By
Geoff Albin
2012/10/19 (first published: 2010/11/17)
|
Source:
SQLServerCentral.com
|
Category:
cpu
Rating:
|
Discuss
|
Briefcase
|
23,462 reads
CPU and Scheduler Performance Monitoring using SQL Server and Excel
This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.
Read more...
By
Derek Colley
2012/10/04
|
Source:
SQLServerCentral.com
|
Category:
sql
Rating:
|
Discuss
|
Briefcase
|
6,780 reads
PBM Policy / WMI query to see which CPUs are in power-saving mode
A simple PBM policy which uses WMI to find out if the CPUs in the target are running at their maximum clock speed.
Read more...
By
Ben Seaman
2011/01/25
|
Source:
SQLServerCentral.com
|
Category:
cpu
Rating:
|
Discuss
|
Briefcase
|
911 reads
How to Monitor for High CPU utilization in SQL Server
This is the method that Geoff Albin has used for years to monitor the CPU on his SQL Servers.
Read more...
By
Geoff Albin
2012/10/19 (first published: 2010/11/17)
|
Source:
SQLServerCentral.com
|
Category:
cpu
Rating:
|
Discuss
|
Briefcase
|
23,462 reads
Items 1 to 5 of 5
Tags
performance tuning
(3)
monitoring
(2)
affinity
(1)
batch requests per sec
(1)
buffer cache hit ratio
(1)
connections
(1)
excel
(1)
graphs
(1)
idle
(1)
indicators
(1)
internals
(1)
kpi
(1)
latch waits per sec
(1)
lock waits per sec
(1)
logins
(1)
logouts
(1)
number of deadlocks per sec
(1)
page life expectancy
(1)
page splits
(1)
perfmon
(1)
policy based management (pbm)
(1)
reporting services (ssrs)
(1)
schedulers
(1)
sql
(1)
sys.dm_os_ring_buffers
(1)
sys.dm_os_schedulers
(1)
sys.dm_os_sysinfo
(1)
total latch wait time
(1)
wmi query
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
