LUNs vs. Meta-LUNs ... to over simplify ... a LUN is a fixed size (e.g 8 Gb) stripe of data space on a RAID5 array. a Meta-LUN is a fixed...

I do not know for sure, but the re-installation of EM surely cannot hurt. Again, the time investment is only a few minutes.

You might also be experiencing skewed results due to buffer and procedure caching. I'd suggest running the following 2 DBCC statements just prior to your execution for each query you...

I have not run into this specific problem before. However I'd opt for just reinstalling EM. It should only take a few minutes and in all probability no reboot.

The real 'elegance' in this thread is Edmundo's post.

Here's a discussion thread from this website ... probably some of is just what you are looking for ...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=263&messageid=264015

I guess coincidence because I've not had the problem since the server move. However in the past I've had similar issues. It related to IE, security and cookies. Have you...

Here's my 'short list' for tuning:

Round I

    DBCC UPDATEUSAGE

    UPDATE STATISTICS (with FULL scan) for all tables

    exec sp_recompile for all tables

    exec sp_refreshview for all views

Round II

    DBCC DBREINDEX

   ...

IMHO acoustical noise level 'issues' in todays technology are not acceptable for a workstation.

New instance implies new system databases and all the associated maintenace, plans, etc. that would be needed just as if one had built a new server. Not a terribly large...

Schema upgrades ... losing data in production of course ... two words ... ErWin ... ErOops !

Maybe we have a slight difference in behaviour due to version ? Vishwas version is v8.00.194 which is 2000 RTM/No SP, and Sergiv's is 8.00.760 which is 2000 SP3/SP3a. Unfortunately...

Here's a handy link ... http://www.connectionstrings.com/

"compatible drivers" ???

Could you please provide a little more information ?

I don't know about 'gotchas' but we have the same issue. So I am building another instance on the non-production server for testing. It seems to be just as easy...