Viewing 15 posts - 7,756 through 7,770 (of 9,253 total)
On a Windows 2008 cluster the install will default to an MNS quorum configuration. You have to actually force it to use a disk which is no longer recommended. You...
August 20, 2010 at 2:08 am
Mani
On the cluster node go into Failover Cluster Manager and at the top of the treeview underneath where it says "failover cluster manager" click on the Windows cluster name.
The centre...
August 20, 2010 at 1:31 am
Mani-584606 (8/19/2010)
Could you please provide me the screen shot where the SQL Server 2008 installation gives the option for selecting the Quorum drive?
It doesnt, the quorum is part of the...
August 19, 2010 at 4:15 pm
quorum will be present as part of the cluster deployment.
Create a DTC clustered application first and then install SQL server
August 19, 2010 at 12:24 pm
SQL_Padre (8/19/2010)
August 19, 2010 at 12:04 pm
onlo (8/18/2010)
and re-started the service.
you have to reboot the server, this is an operating system policy which will be forced by a reboot. Service restart has no effect!
August 19, 2010 at 11:58 am
exec sp_change_users_login 'report'
August 19, 2010 at 11:53 am
make sure the size of your test file is larger than the SAN cache by at least 2 x
Param file should be something like
F:\testfile.dat 2 0x0 4096
Check the Microsoft document...
August 19, 2010 at 11:47 am
you should already have some sort of quorum in force even on the single node cluster.
Create a clustered DTC application and then install SQL Server failover cluster.
The necessary groups, IP...
August 19, 2010 at 11:43 am
Duran (8/19/2010)
set aside 15GB for a quorum,
no you dont!
August 19, 2010 at 8:56 am
Brad
you're welcome, this does trip a few people over 😉
SQL Server when clustered will only use devices that it has dependencies on!
Regards
Perry
August 19, 2010 at 8:53 am
1John19 (1/13/2010)
Somehow VMWare (I suspected) did not allow the sql named instances to use the same port number.
this is nothing to do with VMWare, the Windows Operating System will not...
August 19, 2010 at 4:41 am
SQLIO doesn't test SQL server IO exclusively. It's better for all round IO testing and pushing the SAN to find it's limits. Check the Microsoft documentation that comes with SQLIO!
August 19, 2010 at 4:36 am
george sibbald (8/19/2010)
So if you shrink a data file, rebuild the indexes afterwards.
which could well end up growing the file again anyway!
August 19, 2010 at 4:29 am
Duran (8/19/2010)
Does the number SQL instances have an effect on the size of the quorum? And if so, by how much?
no, the quorum holds cluster configuration info and logs. 512MB...
August 19, 2010 at 4:27 am
Viewing 15 posts - 7,756 through 7,770 (of 9,253 total)