Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag CPU Rss

   Items 1 to 9 of 9   
 

Practical Processor Selection for SQL Server 2014/2016 OLTP Workloads

Glenn Berry explains how you can do some simple analysis to help decide the exact processor to should choose for a new database server, taking into consideration workload and budget constraints.  Read more...
By Additional Articles 2015/09/28 | Source: SQL Server Performance | Category: cpu
Rating: (not yet rated)  Rate this |   Briefcase | 2,208 reads

Top 14 KPI

Get the 14 most used Key Performance Indicators  Read more...
By Monte Kottman 2015/09/22 | Source: SQLServerCentral.com | Category: kpi
Rating: |  Discuss |   Briefcase | 4,306 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 Whitman 2014/02/13 | Source: SQLServerCentral.com | Category: cpu
Rating: |  Discuss |   Briefcase | 1,477 reads

Finding actual number of physical cpu installed

The below query finds out actual number of physical cpu installed on the server   Read more...
By Rahul Singh 2013/01/14 | Source: SQLServerCentral.com | Category: cpu
Rating: |  Discuss |   Briefcase | 1,896 reads

Top 14 KPI

Get the 14 most used Key Performance Indicators  Read more...
By Monte Kottman 2015/09/22 | Source: SQLServerCentral.com | Category: kpi
Rating: |  Discuss |   Briefcase | 4,306 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 | 25,498 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: t-sql
Rating: |  Discuss |   Briefcase | 7,284 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 Whitman 2014/02/13 | Source: SQLServerCentral.com | Category: cpu
Rating: |  Discuss |   Briefcase | 1,477 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 | 25,498 reads
   Items 1 to 9 of 9   
 
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)    
sys.dm_os_ring_buffers (1)    
sys.dm_os_schedulers (1)    
sys.dm_os_sysinfo (1)    
total latch wait time (1)    
t-sql (1)    
wmi query (1)