Perfmon is short for Performance Monitor, which is a tool that comes with Windows Server used to collection performance metrics on servers
3
votes
0answers
40 views
Connection pools being reset with Error: 18056, Severity: 20, State: 46. & Perfmon Counters not showing
We are using SQL authentication & .net 4.0 Connection strings to connect to an Enterprise Edition 2012 SP1 SQL Server on a windows 2008r2 Enterprise Server. We use about 50 Servers split into 8 ...
3
votes
1answer
85 views
Slow SSRS Report in production
I have an SSRS report which gets its data by firing a series of stored procedures.
Now the report is timing out big time when run in production, yet when I pull down the prod database and restore to ...
3
votes
2answers
791 views
How badly do SQL Compilations impact the performance of SQL Server?
I am profiling an instance of a SQL Server 2005 and I, via PerfMon's SQLServer:SQL Statistics - SQL Compilations/sec metric, I see that the average is about 170 or so.
I whipped out SQL Profiler ...
4
votes
2answers
85 views
Mirroring and Buffer Page Write/s
Is the "Buffer Manager: Page writes/sec" (* 8 KBytes) a good indicator of how much bandwidth will be used to replicate all databases via Availability Groups?
If not, why are these not equivalent? Is ...
9
votes
2answers
10k views
High Disk I/O from sql server or is High disk I/O slowing sql server?
I've been arguing with a DBA and a couple hardware guys about performance issues on our SQL server. Normally everything is fine, however over the past few weeks we have been having huge lag spikes in ...
1
vote
0answers
149 views
SQL Server and Perfmon [duplicate]
Possible Duplicate:
SQL 2008 Server agent cant see perfmon counters
I'm trying to setup SQL Server Perfmon counters on a Windows Server 2003 with SQL Server 2005 SP3. I'd like to run ...
2
votes
1answer
305 views
SQL 2008 Server agent cant see perfmon counters
I am trying to create a new SQL server agent alert to capture "SQLServer:General Statistics|Processes Blocked||>|5' but it looks like alert creation GUI is not able to see any perfmon counters as in ...
7
votes
1answer
932 views
When should extended events be used instead of SQL Profiler/perfmon?
The extended events seem like a better technology and less stress on the server, but the SQL Profiler/perfmon has better tooling. Also the extended events seem to have a steeper learning curve. In ...
3
votes
2answers
529 views
DMV Queries as Perfmon Counters
Certain DMV queries that return various statistics that increment since boot would be useful as perfmon counters.
For example, take:
SELECT wait_type, wait_time_ms FROM sys.dm_os_wait_stats;
Most ...
