I assume this must be a 64bit server ? How much physical memory is on the box and what patch level is sql server at?

I tried 1222 and went back to 1204 + 1205.

The issue with any storage and especially SAN storage is having non dedicated spindles for the sql server. It's a tricky situation and the Jim Gray mentioned once that when...

I would suggest the deployment of the performance dashboard if you're running sp2, if you're not then I also suggest you get sp2 and at least 3186 rollup.

There's also dmv...

some of the docs are quite large and the mht files avoid having lots of sub folders, although they do take longer to load. Not all the 2005 pages are...

my experience has been that SAN vendors are very reluctant to provide any type of help or documentation unless you are within a specified channel - that doesn't mean you...

agreed, agreed !!

it's a matter of scale, I usually get 40 - 80 mb per day running the trace flags, it's fine as long as you don't want to read the logs...

I tend to work in fairly large organisations, so with maybe a couple of hundred servers attached to 30 terabytes of storage I don't see 512 luns being excessive -...

you might want to contact me off forum - you're probably heading for a whole load of hurt and if your developers are not sql savvy you may have some...

you pays your money and take your chances! I rarely use the DTA although I'll sometimes run a horrendous query through it , lots of tables, derived tables joins,...

yeah a 4 disk raid 5 gives write performance = to 1 single disk, you'd get roughly 4 times write performance making it a 4 disk raid 10.

do you have any stats and analysis for how your databases are used ? If not then you're just making pure guesses. So many want to split tempdb but put...

updating stats can be intensive and cause problems - but it depends on your hardware,database and table sizes. If we're talking 50gb databases on reasonable raid with multiple cores (...

In general terms you can only capture the information after the event, you can of course capture open transactions ( although they might not be doing much ) and you...