So, for testing purposes, would you use the results from SQL IO Sim or SQL IO ?

It's a Qlogic HBA with a default setting of 16.

I've changed this to 32 (nothing too drastic) and I can see an increase in throughput on SQL IO and a...

I would get a test plan together using a test cluster (if you have one) and include in it;

Rebooting nodes (single & multiple) / removing the witness

Disabling HBAs

Unpresenting disks

Disabling NICs...

Thanks for the response!

Blimey, I was hoping it was going to be a quick job.. but as each cluster's running 6-7 instances I don't think there's anychance of that :rolleyes:

Think...

Sounds like a plan. Let me know how you get on!

Just a suggestion as well. The original post doesn't mention anything about the need to automatically detect the names of over 100 servers..

Sounds to me like a job for powershell.

I don't think you can change them in SSMS.. try deleting the current endpoints and re-creating them using the CREATE ENDPOINT command, specifying the port no. you want to use.

Hi Colin,

I've seen this problem before and I'm pretty sure SQL 2008 will need to use a different Listening Port no. because of the existing 2005 mirror.

Cheers

Sounds to me like you have the same problem as kishorechowdary.erp

Check the permissions on the drive, and if it still fails, try creating a test folder and backup to there.

Goes without saying Corgi.. just keeping it simple 🙂

Just a suggestion! As I said, I don't use them myself..

How about creating a maintenance plan ?

Personally, not a massive fan of maintenance plans but at the same time will do everything you need.

If it lets you backup to the default backup location I would definitely say there's a permissions issue on the D:\.

What if you create a test folder, ie, D:\Test and...

Say for example, you have 10 dbs spread across 10 servers (1 on each). A consolidated server could mean all 10 of these dbs sit on the same server. Therefore...