2
votes
1answer
768 views

PerfMon counters have different Page File % Usage values for _Total and C:\pagefile.sys for SQL Server on VM

I am collecting PerfMon counters on a SQL Server 2008 server (which is hosted on a VM), and I am getting different Page File % Usage values for _Total and C:\pagefile.sys. The C:\pagefile.sys values ...
2
votes
2answers
437 views

Perfmon for SQL Server from local machine

I'm following Brent Ozar's video on Benchmarking and Baselining, and I've got a data collector set on my local machine set up to hit a remote sql server, but I can't get the collection to start. I ...
3
votes
2answers
2k views

Using perfmon, which counters should I pay particular attention to when debugging ASP.NET and SQL performance problems?

Related Perfmon: which counter identifies that threads are waiting? but sadly abandoned by the asker Using perfmon, which counters should I pay particular attention to when debugging ASP.NET and ...
2
votes
2answers
863 views

What SQL Server Query will set perfmon counter “Longest Transaction Running Time” > 0

I'm trying to decide whether this performance counter is worthwhile monitoring: \\SERVER\MSSQL:Transactions\Longest Transaction Running Time. So during testing I tried to create some long running ...