Thanks all for reviewing my perfmon numbers.

I talked with the SAN team some more today. There are no errors to correlate. The network backups run from 6PM to 4AM, which...

Just one more thought on this before I post more results tomorrow.

I notice this error is also occurring on my Log drive in Development, which is also a virtual server.

Could...

I monitored again last night, and again, last night I the error.

One of the error times recorded is 7:04PM

This is the monitor results from 6:58:50PM to 7:04:47PM (5 minutes,...

A little more information:

I have a dedicated pipe to the SAN, however the server is sharing resources with other processes. So at least I am not sharing request threads, however,...

Thank you all for your feedback!

I will try your suggestions and post back the results.

As for LUNs, we are actually using Blades. I spoke with our SAN admin and...

Thanks! I will look into it - I'm also working with the SAN administrator - I'm going to ask him what each disk can handle for IOPs - anything else...

Thanks for looking this over,

I guess I'm just trying to figure out if this is "normal" performance - this is my first server on a SAN - and I'm...

Absolutely!

Here is the before averages:

LogicalDisk__TotalDrives__Percent_Free_Space: 95.210

Memory__Available_Bytes: 1971428112

Memory__Pages_Sec: 0.045

NetworkInterface__MS_TCP_Loopback__Bytes_Received_Sec: 0.000

NetworkInterface__MS_TCP_Loopback__Bytes_SentSec: 0.000

PhysicalDisk__TotalDrives__Percent_Disk_Time: 0.104

PhysicalDisk__TotalDrives__Avg_Disk_Queue_Length: 0.003

PhysicalDisk__TotalDrives__Disk_Reads_Sec: 0.004

Processor__TotalDrives__Percent_Processor_Time: 1.660

SQLServerBufferCacheManager__Buffer_Cache_Hit_Ratio: 99.864

SQLServerGeneralStatistics__User_Connections: 10

SQLServerPlanCache__TotalDrives__Cache_Hit_Ratio: 94.417

System_Processor_Queue_Length: 0.000

Here are the "during" numbers:

LogicalDisk__TotalDrives__Percent_Free_Space: 86.029

Memory__Available_Bytes: 1581303685

Memory__Pages_Sec: 0.000 (however I have seen...

I ran a dbcc checktable on sysdatabases and there was no error reported out. I checked my documentation and the compared the database ids and there is no difference from...

Thanks for the link - I also saw this and did run a CheckDB to see if any errors returned, alas nothing.

There hasn't been any changes or restores - however,...

Thanks,

Unfortunately no - this is the only error message, and I had to profile it to receive it.

Thanks for the BP link as well, have never seen that one...

Yes, that's correct, it runs under the Service or Agent account, depending on if you execute directly or schedule in a job. The problem is that I cannot change the...

Yeah, I think I tried too hard to keep it online! LOL

I have restored to yesterday's backup - this is just a development database so no harm no foul, I...

One final note on this thread -

I decided to use shell script to delete. Actually, I deployed a solution posted on SQL Server Central from http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/30066/

The shell...

No luck 🙁 I get the syntax for the following. Do you know is there a way to do Differential backups in a maintenance plan in 2000? I may...