PANIC IN THE DATACENTER! Your databases are approaching – or surpassed – the Terrible Terabyte mark. You’re pouring money into the SAN, but your data isn’t pouring back out as fast as you want. You’re terrified to DBCCs or index maintenance because everything takes forever, and you don’t have big maintenance windows.
Take a deep breath. In this session, you’ll learn the things your SAN admin doesn’t even know, like how to configure your databases for iSCSI, how to make multipathing work for you, and how to leverage solid state drives without paying crazy prices.
Another nice presentation and thank you for sharing your experience …!
Nice presentation. Wish to see more..
A question,
Not sure how the locks are handled in SQL server cluster environment. Ex: db2 uses coupling facility and oracle uses fusion(reads all node memory). I felt coupling facility is more efficient. Pl let me know.
Padhu – in a SQL Server 2008 cluster, only one node is active for a particular database at a time. Other nodes can’t grab locks on the database.
Brent,
You are so quick.. Thanks.
If locks are kept in one node only, looks to me the scalability is limited. Ex: two instances of same transaction to run on two different node. It sounds like standalone server. May be I am missing something here.
-padhu.
Padhu – SQL Server clustering isn’t a scale-out solution. For scaling out, you’ll want to investigate solutions like replication, log shipping, and the new AlwaysOn features in the upcoming release:
http://www.brentozar.com/archive/2010/11/sql-server-denali-database-mirroring-rocks/
Thanks.
The download links in this page give 404 error. I could not download the videos or the presentation.
Subhrajyoti – thanks for the heads-up! I updated the link – looks like SQLbits changed their URLs.