Is that mean backing the whole volume...

thank you,

I understand that perfmon gives accurate values but when we have SAN it's near impossible to interpret correct values for Avg.Disk Queue length.

Question:

Is this applicable to Avg. Disk sec/Read...

thank you,

If the storage is from SAN, the readings from Perfmon for the below counters will be the correct values unlike Avg Disk Queue length?

Average Disk Seconds/Read

Average Disk Seconds/write

thanks

thanks Gail,

Is there a way to find the correct...

Thanks,

I have multiplied the PhysicalDisk(1 D:)\Avg. Disk sec/Read & Avg. Disk sec/Write by 1000 to get the value in ms and most of the values are with in...

We have SQL Server 2005 Standard edition with SP3. And from the link http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/5d33cdc5-998c-4b11-8b8a-372d6abca723?prof=required

if we ran a report which will bring large data, then blocking from ReportserverTempdb is normal....

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/5d33cdc5-998c-4b11-8b8a-372d6abca723?prof=required

I went through the above link which addresses this issue. Is having blocking with reportservertempdb normal?

please advice

It's a 3 node cluster and the shared drives are on SAN and the backup drive is also on SAN

thanks for your help

These are BizTalk related jobs and initially they were cretaed with the owner Btsadmin. Later we changed the owner to Administrator account and it's worked fine and working fine in...

I got the same error last night when the server got rebooted?

So every time the server restarts,. I'm getting this issue and to avoid the issue I'm changing the owner...

Currently, on C drive(we have only one local drive i.e C), the page file is set to default size of 2046 MB

Thank you

I Appreciate if some body shed some light on having (requirement of) separate local drive for page file and page file size = ~1.5 times of RAM in a clustered...

Sorry, it's my mistake. Actually we do not have a database with database_Id =6. That's I'm getting the error.

For the rest of the databases, I'm able to get the results.

thank...

It's a server in work group and the user logged in is a member of the Administrator account. So the user will have Administrative rights to log in SQL Server?

thank...

Delete or rename the .dll on the server where it's not working. Then add a copy from the server that is working and re-register it. It could be that the...