Upon further review...

The primay issue is expected SQL 2000 SP4 behavior according to http://support.microsoft.com/kb/906344.

Thanks, Dave

Thanks. Sounds like I may have a memory or disk bottleneck. I do see some paging issues so I'll problably add some memory to see if this addressess...

I go away on vacation (Disney) for a week and come back to find some good discussions. Thanks everyone for the feedback on this topic.

Any suggestions on what Events to...

The case sensitivity thing is a new one for me also. I still don't understand why I am getting SP:CacheMiss followed by SP:CacheHit every time I execute a proc....

The test proc ran SELECT * FROM TABLE_NAME. That's it.

I'll check out the link. Thanks.

I have 2GB reserved for the OS and SQL is configured to use a maximum of 8GB. The pagefile use isn't even 1%...

Run DBCC Memorystatus to look for problems and run the Memory Consumption report.

That much pagefile usage indicates a memory problem. If memory is set correctly you should only see a minimum amount of the pagefile being accessed. The main reason...

Now I got it. Thanks.

It's the same thought as a locally-attached "expanded volume". As in - if you have a volume directly attached, and it starts running out of disk space, you can...

You say virtual LUN so does this mean the RAID is a software RAID and not hardware. I always thought a set of disks could only have one hardware...

Are you saying you have a RAID 10 and RAID 5 running at the same time on the same set of disks? Is that even possible?

They sent me some white papers and I'm going to have a call with an EMC SQL rep tomorrow.

Thanks

Thought I would chime in on this topic. We noticed the same thing regarding the inability to generate a script containing the members of fixed database roles in 2005....

Thanks. This will be helpful. I'm still going to contact Microsoft regarding what I believe to be a bug in their scripting process. It shouldn't take an...