Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag PerfMon Rss

   Items 1 to 6 of 6   
 

Paging Doctor Powershell

Use Powershell to create a single script that checks over your server and every SQL instance on it to help pinpoint problems.  Read more...
By Zach Mattson 2014/04/11 (first published: 2011/04/04) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 11,202 reads

Excel Function Returns Cell Address

This article details an Excel 2010 function to return the cell address of min and max functions.  Read more...
By Russ Mulkey 2013/06/04 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 5,734 reads

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,574 reads

Transaction Replication Latency Diagnosis

Identify resource bottlenecks in a stressed transaction replication topology using PERFMON/PAL and system wait stats  Read more...
By Paul Brewer 2012/05/09 | Source: SQLServerCentral.com | Category: perfmon
Rating: |  Discuss |   Briefcase | 2,035 reads

Working with Perfmon CSV logs in Powershell

When all you have is Powershell and perfmon logs, here's a way you can use them together to perform some analysis.  Read more...
By Hemanth Damecharla 2012/03/05 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,924 reads

Paging Doctor Powershell

Use Powershell to create a single script that checks over your server and every SQL instance on it to help pinpoint problems.  Read more...
By Zach Mattson 2014/04/11 (first published: 2011/04/04) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 11,202 reads
   Items 1 to 6 of 6   
 
Tags
csv (2)    
powershell (2)    
batch requests per sec (1)    
blg (1)    
buffer cache hit ratio (1)    
connections (1)    
cpu (1)    
event log (1)    
excel (1)    
idle (1)    
indicators (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)    
pal (1)    
performance tuning (1)    
replication (1)    
sql server (1)    
sqlstress (1)    
total latch wait time (1)    
troubleshooting (1)