0
votes
1answer
91 views

SQL Server Timeout issues at random times causing performance degradation

I am having random timeout during a brief period of time on certain days. My CPU, Memory looks fine. So I ran Performance Monitor during these spikes and found my average disk sec/read was 5.8 ...
0
votes
2answers
597 views

Perfmon counters for monitoring general IIS/MSSQL server activity

I have a virtual server with a hosting company so CPU and RAM are limited. I need to watch load/performance over time to know when to upgrade the server. The site runs multiple ASP.NET apps as well ...
1
vote
1answer
280 views

Remote Performance Monitoring SQL Server

I've got a couple of servers running SQL Server 2005 Enterprise and I'd like to monitor them remotely using Perfmon (Windows' Performance Monitor). On my machine, I have an instance of SQL Server ...
0
votes
1answer
67 views

Performance analytics via DBMS “plugins”, or other solution

I'm working on a systems monitoring product that currently focuses on performance at the system level. We're expanding out to monitoring database systems. Right now we can fetch simple performance ...
-1
votes
3answers
135 views

Server Monitoring Options [duplicate]

I'm trying to find the best way to monitor my MS SQL server. I have been using pingdom for my web server and want to look at something else. I have done a lot of googleing but they all seem to be the ...
0
votes
1answer
226 views

dm_exec_query_stats returns worker time greater than elapsed time

I frequently query sys.dm_exec_query_stats to find expensive queries. I've noticed that in some cases the total_worker_time is greater than the total_elapsed_time. Does anyone know why this would be ...
1
vote
4answers
1k views

High CXPACKET wait type in SQL Server even with MAXDOP = 1

I have always had a very high CXPACKET wait type, and I've been told that it stems from parallel processing, and I should keep MAXIMUM DEGREE OF PARALLELISM = (Nº Processors / 4), or 1 in my case. ...
1
vote
1answer
186 views

Measuring SQL Server performance improvement

We just got approval to purchase a new database server. My manager is worried that, after we deploy the new server, some users might not perceive the improvement in performance. I've been tasked to ...
4
votes
2answers
1k views

Log perfmon data to SQL Server

I am trying to log perfmon log (Windows Server 2008) to SQL Server 2005 (Windows Server 2003) using dsn (SQL Server authentication). On start perfmon counter i am getting error: "Call to ...
0
votes
4answers
2k views

Performance Monitor w/ SQL Server - how many counters is too many?

I'm doing some performance analysis using the built-in Windows Performance Monitor, both on general hardware and SQL Server. I've been reading a lot about which performance counters to use; in ...
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 ...
1
vote
2answers
484 views

What's the best way to monitor SQL Server Concurrency issues?

What's the best way to monitor SQL Server Conccurency issues? Specifically my goal is to reduce or prevent deadlocks and blocking and to catch potential concerns before they become a problem. For ...
0
votes
2answers
89 views

No data coming from the perfmon statistic SQL Server: Replication Dist

I am trying to get the statistics from my 2008 sql server replication SQL Server: Replication Dist. statistics, but no data is coming even while replication is in full swing. I am using SQL 2008 ...
2
votes
1answer
1k views

what should be monitored for baseline sql server performance

What are the baseline perfmon counters for monitoring SQL Server and what do they mean?
3
votes
2answers
311 views

Justifying a memory upgrade, take 2

Previously I asked a question on what metrics I should measure (e.g. before and after) to justify a memory upgrade. Perfmon was suggested. I'd like to know which specific perfmon counters I should ...
2
votes
1answer
594 views

SQL Server “Long running transaction” performance counter: why no workee?

Please explain to me the following observation: I have the following piece of T-SQL code that I run from SSMS: BEGIN TRAN SELECT COUNT (*) FROM m WHERE m.[x] = 123456 or m.[y] IN (SELECT f.x FROM ...
2
votes
1answer
454 views

Where has performance monitor SQL logging gone in Windows 2008?

I'm quite used to having the option of logging windows performance counters to an MSSQL database since Windows 2000. I've just tried setting up some performance counters on a new machine today and ...
1
vote
2answers
326 views

How do I objectively measure an application's load on a server

All, I'm not even sure where to begin looking for resources to answer my question, and I realize that speculation about this kind of thing is highly subjective. I need help determining what class of ...
2
votes
1answer
4k views

Setting up remote access to Performance Monitor

I can't seem to find a simple, step-by-step tutorial on how to use Performance Monitor remotely. I just want to give non-admin rights to one of our DBA guys so he can get the results he needs from ...
1
vote
2answers
404 views

Which Performance Counters to use for SQL Server 2005 Express

Usage Scenario I have a SQL 2005 database running in an instance of SQL Server 2005 Express Edition. There are two different .Net applications running that constantly connect to this database and ...
2
votes
2answers
2k views

How do you fix the Performance Dashboard datetime overfow error

I'm a programmer/DBA by accident and we're running SQL Server 2005 with Performance Dashboard for basic monitoring. The server has been up for a few weeks and now we can't drill into certain reports. ...
3
votes
1answer
610 views

windows server 2003 monitoring software combining SQL Server monitoring with CPU-IO stats

I'm aware this type of question has been asked many times before: http://serverfault.com/questions/499/how-to-monitor-bandwidth-usage-in-real-terms ...