Questions tagged [perfmon]
Perfmon is short for Performance Monitor, which is a tool that comes with Windows Server used to collection performance metrics on servers
39
questions
0
votes
0answers
10 views
In SQL Server, data returned by sys.dm_os_performance_counters for “SQLServer:Broker Statistics” is not changing over time
In SQL Server [Microsoft SQL Server 2016 (SP2-CU10) (KB4524334) - 13.0.5492.2 (X64)], I'm trying to determine just how much activity our Service Broker queues are processing. One tactic is to use sys....
0
votes
0answers
50 views
Get-Counter not accepting array created from SQL
When I try and generate an array from a SQL output, although it's the same data type and content, perfmon doesn't accept these values, whereas it does for a manually created a list. So the first call ...
0
votes
0answers
91 views
Why are my SQL Perfmon counters returning Zero?
I have set up a Perfmon data collector set on one of our servers with SQL server running on it. I also have a scheduled task which imports this data into SQL (set up by following this open source ...
0
votes
1answer
401 views
How to create SQL Server Agent Queued jobs?
There is a perfmon counter "Queued jobs" in perfmon object "SQLAgent:Jobs".
How to create a job queue that will reflect in this perfmon counter?
Can I get this queued job info from somewhere else ...
0
votes
2answers
486 views
Strangely high writes per second
I'm experiencing some extremely strange behavior on one of our OLTP Servers. Just to provide a bit of background, we have an 'OLTP' which has many large and wide tables. We have 560 tables within it ...
1
vote
0answers
148 views
Cost / Capacity Planning: Quantify Data Ingress / Egress
To evaluate the migration of an on-prem SQL Server to a cloud-hosted VM, I want two fundamental pieces of information:
The list of clients that access the on-prem DB Server. I'd like to know: client ...
1
vote
1answer
912 views
Why “Data File(s) Used Size (KB)” PerfMon counter doesn't exist?
I wanted to create my own SQL Server baseline by collecting data with the Performance Monitor.
Among all counters that I have decided to monitor, I also wanted to have a historic trend about data ...
3
votes
1answer
521 views
Cpu-Alert in SQL Server -2012 standard edition
My question is an extension to this.
We have SQL Server Agent alerts(Deadlocks, Network IO etc) to monitor SQL Server performance. So i would like to write an alert for CPU increase percentage. ...
0
votes
2answers
2k views
Need to setup a sql alert on “waiting tasks” - similar to “waiting tasks” in Activity Monitor
My manager has asked me to work upon a request. I am not sure if it is reasonable or weird but he wants me to setup an alert based on the "waiting task" that we see in the activity monitor. Basically, ...
0
votes
2answers
532 views
SQL Server target/total server memory is not equal to sum of database size in dm_os_buffer_descriptors
I am having an issue in my SQL Server like high memory paging rate and more compilation/sec which lead me to a different observation in memory, so first i checked what is total size of memory of ...
1
vote
1answer
180 views
SQL Server : Perfmon Counter Incorrect value
I'm trying to understand why this Performance counter shows it is 0.
"Mssql$instance1:locks(_total)\lock wait time (ms)"
I tried with wild card to check all instance_name and they're all 0.
...
0
votes
1answer
26 views
Are 'per second' Performance Counters measured over a certain period of time? [duplicate]
This may be a very silly question, but when I'm looking at the current value of a 'per second' counter in PerfMon, for example SQL Statistics\Batch Requests/sec - how is that value actually measured?
...
2
votes
2answers
490 views
VMWare Memory Sizing and SQL Server 2014
We have a production server that dumps it's Page Life Expectancy many times a day (climbs to 2500s and falls back to near 0s)... After watching some training videos about virtualization for SQL Server,...
1
vote
2answers
471 views
Access to performance counters from T-SQL procedure
I want to write a stored procedure, which is returning CPU utilisation, Memory utilisation and Count of rows in table T1. So it should look like:
SELECT cpu, memory, (SELECT COUNT(*) FROM T1) as ...
1
vote
0answers
38 views
Beefing up capacity of existing AAG cluster
I am planning to add 3 new databases to an existing AAG cluster in a VM. The AAG has Veeam databases on it as of now. Veeam backups are not running on it as of now apart from a couple of batch ...
4
votes
2answers
1k views
How can I extract the perfmon counter “Memory: Pages/Sec” using t-sql?
I've googled this and so far, no luck so turning to all you awesome gurus for help.
I'm trying to figure out if there's a way to get the perfmon counter "Memory: Pages/Sec" using t-sql as I'm trying ...
7
votes
2answers
888 views
How to measure Key Lookups per Second on SQL Server
I am working on reducing the amount of transactions doing key lookups on our SQL Servers.
First I want to define a baseline for the normal or tolerable number on that metric and as we constantly ...
2
votes
0answers
286 views
Memory\Pool Nonpaged Bytes low but Memory\Pool Paged Bytes high
Can someone help identify how these values can indicate memory leak.
In the system I am monitoring Memory\Pool Nonpaged Bytes are low (on average 100mb) but Memory\Pool Paged Bytes are high (on ...
5
votes
1answer
975 views
SQL Server - comparing PageSplits/sec with Batch Requests/Sec
I read here (http://www.databasejournal.com/features/mssql/article.php/3932406/Top-10-SQL-Server-Counters-for-Monitoring-SQL-Server-Performance.htm) that having a high value of PageSplits/sec compared ...
2
votes
1answer
400 views
Howto use typeperf to store performance monitor values in a custom schema?
I have setup a performance monitoring of my SQL server system using typeperf.exe to store the values directly to SQL Server.
I went through the following article, that explains howto use typperf.exe ...
2
votes
1answer
81 views
Any merit to MSSQLSERVER Trace from logman as opposed to XEvent Package 0
The general understanding of monitoring SQL Server activity is that using SQL Profiler is very heavy, server side traces are less heavy, but extended events are even less heavy.
Today I discovered ...
9
votes
4answers
14k views
Monitoring free space in SQL Server data files
I have manually resized mdf/ndf files to a big size to avoid autogrow operations on SQL Server databases.
Since the files are bigger there is very little free space on disk partitions and the ...
3
votes
2answers
247 views
What perfmon counters should I use to get the fastest restore possible on an idle system?
I have a development VM running Windows 2012-R2 and Sql Server 2014. I have one disk from a SAN holding the OS and SQL. My backup file is stored locally on the disk.
I want to restore database as ...
3
votes
1answer
771 views
Perfmon and SQL Server Clustering
I'll be going onsite to run some performance tests for a client. They have a Windows Failover Cluster, which has a clustered instance of SQL Server. Let's assume for this post that my client's ...
1
vote
1answer
15k views
Understanding pagefile.sys % Usage performance monitor (perfmon) counter correctly
Lately we run into performance inssues and I started tracking some recommended sql, memory, disk and cpu counters. I informed myself about the recommended values and numbers to look at.
One of the ...
2
votes
1answer
4k views
Get the application name
Is it possible -- does a perfmon counter exist -- that would show the name of the end-user application that is connecting to SQL Server?
5
votes
1answer
8k views
SQL Server PerfMon: Compilations/sec > Batch Requests/sec
I've been looking at various PerfMon metrics on one of our client's SQL Server instances trying to get a good gauge of where our database (or server) could use improvements.
One measure that has me ...
1
vote
2answers
3k views
Performance counter MSSQLInstance\SQL Errors\Errors/sec\Info Errors whats in it?
Im wondering what kind of errors would show up in the:
SQL Errors\Errors/sec\Info errors
performance counter. I read the TechNet article it just states:
Information related to error messages ...
1
vote
0answers
1k views
SQL Server: Batch Requests/sec showed increase in performance, but performance actually decreased
We are currently on SQL Server 2005, with a plan to move to SQL 2012. To make this move we have to test new database drivers for the application (Java). We performed 2 load tests using the 2 different ...
3
votes
4answers
5k views
SQL Server Page Life Expectancy sharp drop
I'm trying to put my hands on the reason this SQL Server slows down sporadically. There are no patterns detected so far.
It's a SQL Server 2008 R2 running on a Windows Server 2008R2 VM on top of ...
2
votes
1answer
2k views
Reading SQL Performance Counters using PowerShell script
I'm trying create a PS script to read some performance counter about my SQL for my Level 1 partners but I'm having a problem with the instance name.
I'm using this code:
$computer = "\\\" + $ENV:...
24
votes
2answers
24k 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
130 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 ...
19
votes
3answers
81k 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 ...
11
votes
5answers
15k views
How to revive SQL Server 2008 R2 performance counters?
I'm running SQL Server 2008 R2 Developer on Windows 7 x64, as the default instance. For some reason, SQL Server's performance counters seem to have disappeared. SELECT * FROM sys....
1
vote
0answers
158 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 counters on ...
3
votes
1answer
790 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 ...
21
votes
1answer
4k 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 ...
5
votes
2answers
1k 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 ...
