November 4, 2010 at 1:13 pm
Hi,
Are there any good references on SQL 2008 clustering, including installation, administration, monitoring, troubleshooting etc.?
BOL is no good IMO.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 4, 2010 at 6:08 pm
That would be something wouldn't it.
SQL Server is managed in the same way you would manage a normal instance of SQL Server, what changes is the complexity of the underlying operating system. Items such as storage, IP addresses, DNS and network names are managed differently. This all changes again when moving from Windows 2003 to Windows 2008!
You can download my cluster install guide at the following links. The guides are quite large so right click the link and select save as
Windows 2003 and SQL Server 2008
Windows 2008 and SQL Server 2008
Only by setting up your own cluster from scratch and playing with it will you gain sufficient understanding and knowledge.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2010 at 6:59 pm
Perry Whittle (11/4/2010)
That would be something wouldn't it.SQL Server is managed in the same way you would manage a normal instance of SQL Server, what changes is the complexity of the underlying operating system. Items such as storage, IP addresses, DNS and network names are managed differently. This all changes again when moving from Windows 2003 to Windows 2008!
You can download my cluster install guide at the following links. The guides are quite large so right click the link and select save as
Windows 2003 and SQL Server 2008
Windows 2008 and SQL Server 2008
Only by setting up your own cluster from scratch and playing with it will you gain sufficient understanding and knowledge.
Thank you for the info! I will be installing my 2nd cluster in a few days, it will be an active-active cluster.
Any special precautions I should know about on active-active clusters?
I will go through the links you provided.
Thanks again!
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 4, 2010 at 7:12 pm
Perry Whittle (11/4/2010)
That would be something wouldn't it.SQL Server is managed in the same way you would manage a normal instance of SQL Server, what changes is the complexity of the underlying operating system. Items such as storage, IP addresses, DNS and network names are managed differently. This all changes again when moving from Windows 2003 to Windows 2008!
You can download my cluster install guide at the following links. The guides are quite large so right click the link and select save as
Windows 2003 and SQL Server 2008
Windows 2008 and SQL Server 2008
Only by setting up your own cluster from scratch and playing with it will you gain sufficient understanding and knowledge.
I think the 2 urls you provided are both for Win 2003;
would you have the doc for Win 2008?
Much appreciated.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 5, 2010 at 8:11 am
Hi
sorry, my bad. I had posted the same link twice but have corrected that now. Right click the link and download the file before trying to open!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2010 at 9:30 am
Will do, thanks!
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply