Viewing 14 posts - 1 through 14 (of 14 total)
Ah ha! That's what i get got assuming it was like 2005, and not reading the instructions. This worked, and I'll set!
November 12, 2010 at 12:46 pm
Im just testing it one table at a time right now to check the same sort of thing.
October 8, 2010 at 6:51 am
I was going to test this today, but when I started, I got an error telling me that the cluster shared disk was not available. How can that be...
October 8, 2010 at 5:19 am
here are some more stats after running that script:
0NULL ...
October 8, 2010 at 5:06 am
it says Command Completed Successfully, but when I recheck the stats, they are what they are...
October 8, 2010 at 4:56 am
here are the stats with page count:
0NULL33.41317365269466530
2UQ__idxname1__5441852A78.77697841726621668
October 8, 2010 at 4:35 am
As you can see, it is showing an avg frag percent of 78 which is crazy. I've tried to re-index that db with the script below, but those numbers...
October 8, 2010 at 4:25 am
Even when I run it in the proper place, I get output like this, indicating a null value:
0NULL33.4131736526946
2UQ__ixname1__5441852A78.7769784172662
October 8, 2010 at 4:23 am
Ah, that's not a bad idea, just installing a different instance and moving the db's.....Can that be done from RDP (e.g. the SQL cluster installation part)? The windows OS...
October 7, 2010 at 10:04 pm
Excellent. Thanks everyone for all your help!
September 23, 2010 at 11:59 am
This one is going to be 2008. I've never set up before on 2008, but I've done about 4 2003 Active/Passive clusters.
September 23, 2010 at 9:00 am
So do I need to quorums? How do I get two servers to read from the same quorum?
September 23, 2010 at 6:51 am
So do I set this up as two clusters? Or are there better instructions somewhere?
September 23, 2010 at 6:26 am
Anyone have any ideas? Anyone? Anyone?
August 31, 2010 at 9:26 am
Viewing 14 posts - 1 through 14 (of 14 total)