Hi Roy,

Yes i should have updated that i found the answer already.

Thanks for the input though 🙂

S

Ok so this is the SP,

Im not sure where to look now. If i start from the top and work down 27 lines skipping /* and blank lines...

This is the area where the code fails is below in the sp.. sorry would help im guessing!

/* Update the ParameterRowID field for easier querying */

...

Nadrek,

simple but genius!

thanks..

Manufacturer replied..

When i created the vols for the RAID 10s (1 with 6 disks and 1 with 8 disks) and RAID with the default max vol size.

They have asked...

Hi all,

yeah thats a really simple way that i should have thought off (Size of the volume)

So it is in RAID10 but we are just getting performance fitting...

Hi Brandie,

Thanks for help and the nod that it seems im going in the right direction.. Phone call is on to SAN vendors, So hoping I can get...

OK....

I think i see whats happening.. I think our SAN has just done RAID 1 with 6 and 8 disks not RAID 10!

Wiki on RAID 1:

In RAID 1 (mirroring...

First thanks for all the info... SAN design/performance/monitoring is something i want to look into and start doing as we dont really do it here. Any advice on where to...

Hi thanks for the reply..

But is possible to use Pull subscriptions on express? via a script..

then create a quick button to run the script and joy!

cheers

s

hi Greg,

Yeah that seems like a great to super numbers, but apparently our SAN dosnt handle true multipathing. As i said above (Think i wrote it same time as...

any info would great ty..

ive read things like brent ozars chapter in internals and troubleshooting. watched a few vids on configuring you SAN etc..

This is a brand new...

Sigh...

resolved the problem...

I had apparently checked if tcp and pipes were enabled in 32bit but not 64bit. Once i enabled them and restarted the SQL Service its working......

Still got this problem

tried the random idea of it being SP1 that caused the problem so removed SP1, but still cant connect.

Suammry:

2008 r2 Dev edt

remote connections allowed

sql browser...

Hi Brandie,

Yeah i figured there would be a ways to improve it, but it seemed a lot higher.. and ive never got mine any where near there.

thanks for the reply