0
votes
1answer
48 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
0answers
39 views

What is a good set of performance counters to measure scalability bottlenecks

We're moving our enterprise product to the cloud (IAAS) and are determining how many users we can support on a single VM. Our product uses SQL Server, SharePoint and a bunch of WCF services. What ...
4
votes
2answers
416 views

32bit SQLServer with AWE NOT enabled. Buffer Cache Hit Ratio High, Disk Read Queue VERY HIGH, WHY?

We have a "SQLServer 2005 SP3 32bit Enterprise Edition" running on a 32 bit Windows 2003 32bit Enterprise Edition 12GB RAM with AWE enabled using RAID5(5 pysical disks). We tuned AWE to enabled and ...
0
votes
2answers
317 views

SQL Server 2005 Performance Counters Missing

I wanted to do some performance monitoring on one of our blade servers here at the bank., but ran into a little stumbling block. When trying to create a pretty standard counter log, via performance ...
1
vote
2answers
1k views

No permission to access SQL server perfmon counters

My DBA team doesn't have access to SQL server 2005 standard performance counters. What is the required permission that they should be granted? I found some registry entries, but they already have ...