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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy