Thanks for your response Grant.. What would you say is reasonable amount of time to measure over ?

Cheers

Vultar

Get the free SQLIO tool and gather stats from that too. That will give you a best-case baseline for disk io (and, if the numbers aren't good/right, allow you to...

Thanks for the quick responses.. sorry I should have been a little clearer in my original post.

The 'server', is actually a 4 node 2k8 R2 cluster which is going to...

Hello,

As a test, what happens if you create a new SQL account and then try logging onto the instance using it ?

Cheers

Vultar

No probs, I didn't find it straight away.. thought it was me mis-reading your instructions 😉

Thanks again

Cheers

Vultar

Dev - I'd guessed they would probably behave the same but wanted to double check more anything.

NJ-DBA - That's worked a treat, much better & safer than editing the registry.

Thanks...

For a good overview / starting point for SQL Server Db Admin I would read the material aimed towards getting the 70-432 SQL Maintenance & Admin certification, in particular the...

Thanks for this, however it doesn't mention anything about making registry key changes against a clustered instance, which is what I want to do.

Cheers

Vultar

Do you need to have 2 copies of the backup.. 1 locally and 1 on the share ?

If you only need 1 copy you could backup straight to a network...

1st things 1st, I'd check there's a good backup schedule in place and that you're able to use these backups in the event of a disaster, after doing that I'd...

Maybe a silly question.. can you ping the server ?

Cheers

Vultar

Thanks for posting the code up, I didn't think of doing it that way.. much quicker than the way I suggested so I'll have to remember that one!

Cheers

Vultar

I'm all for mount points for the main reason that I can conserve drive letters. We're running a couple 2k8 R2 clusters, each with 5/6 instances, with separate drives for...

I've set some policies based around db settings like auto-shrink, auto-growth, etc. Have a look at this if your looking for a good reason to set some policies;

http://epmframework.codeplex.com/

Cheers

Vultar

Here's a good link to help you understand the output from SQL IO Sim;

http://sqlblog.com/blogs/kevin_kline/archive/2007/06/28/understanding-sqliosim-output.aspx

Cheers

Vultar