It depends on many factors, including IO, CPU usage, as well as SAN performance.

I've had some success with low/medium use databases in a virtual environment, as well as some...

I have experienced similar symptoms if the server engineers use WSUS (or similar) to automatically apply SQL Security fixes. If the kb's cant be installed successfully, I think the default...

You can "reverse engineer" the user security and use this to create a new user. There are a few scripts floating around for this- you should be able to find...

I would run perfmon for an extended period (saving the .BLG file) and then use PAL to analyse the results. This will capture network/disk/memory/CPU etc (depending on your chosen counters)...

Thanks for the information David!

We are running 6.5.5 and still having issues- I will mention this to the server admin team...

Thanks again 🙂

Is this Windows 2008 64 bit also? Which version of Netbackup? We are having some issues with Netbackup and 64 bit SQL 2008...

We generally use Windows collation on the newer SQL builds. There is no reason you can't have the same collation in SQL 2000/2005/2008 if you choose a windows collation.

This...

Keep this in mind though (depending on VMWare version):

http://www.mikedipetrillo.com/mikedvirtualization/2008/12/using-perfmon-in-a-windows-vm.html

You can often get inaccurate results...

What does the event log say 🙂

I don't think this is persistently stored within SQL Server, but you can gather the information from Perfmon. What we do is plot a count of the current connections every...

Hi,

There are quite a few (from my experience). Some around 64 bit, DTSRun, editing packages etc. Here is some Microsoft information to get you started:

http://msdn.microsoft.com/en-us/library/cc707786.aspx

http://msdn.microsoft.com/en-us/library/ms137907.aspx

From my experience, you really don't want to put tempdb on RAID5. I inherited a server setup like that and as soon as I moved the tempdb to RAID1 the...

I guess it depends on how much data you are writing...you may not notice the difference if it's not huge, however RAID 5 should be sloooow (it always is for...

I suppose if the path and security where tempdb is configured is setup on the new drive, it should work.

What about RAID 1? it would be nice to have some...

I have seen this happen with certain models of servers, when SQL Server is practically idle- you can check your firmware is up to date (if SQL itself looks ok).