At 11AM Eastern, I’m giving a free webcast on Virtualization and SAN Basics for SQL Server database administrators. Here’s a few links for attendees:
- Virtualization Articles
- SAN Articles
- Slide Deck – in case you’d like to download it, fire up the projector, and pretend you’re me.
- Virtumania Podcast – I was the guest this week on a fun one-hour podcast covering SQL Server virtualization.
- Virtualization.SQLPass.org – the Professional Association for SQL Server virtual chapter.
- Rate this Webcast – if you liked it, or you thought it blew chunks, let me know!
- Professional SQL Server 2008 Internals and Troubleshooting – our book, on sale at Amazon – we’re up to eight 5-star reviews!
By the end of the day, the archive will be available here – at the bottom of the page, next to our race car book, there will be a link that says View Recording. Click it. Become smarter.
Brent: will you be archiving this webcast for future viewing? Just ran into an unknown roadblock in having to apply for LiveMeeting access through our firewall… Was looking forward to the show.
Yep! The archive link is in the post above.
Fabulous! Looking forward to it!
Brent,
That was probably one of the better webinars (virtualization and san basics) I’ve seen. Tons of good and USEFUL info. Your fan-base has just increased by one.
Thank you very much for sharing!
Drew
Thanks, sir, glad you liked it!
Great presentation today, Brent! I already see a couple of things we’re doing here in our virtual (VMWare) SQL Server environments that need to be changed. Thanks for the timely information.
Justin
Great presentation Brent! The tidbit on overhead related to multiple virtual CPUs was a real eye-opener!
Brent,
I tried to view the archived presentation at the link you provided, but all I get is this error message:
This Webinar is over
Webinar Over
The following Webinar is not available:
Virtualization and SAN Basics for DBAs
Doh! Sorry about that, I’ve got an email in to Pragmatic to find out what’s going on.
Is this webcast similar to the one you did back in February? You told me on twitter that the recording didn’t go so well. I really hope this isn’t the case on this go-around!
Chris – yep, they’re working on fixing the recording now. Thanks!
Sweetness!
Hi
We are working on a client ESX server (vsphere 4.0)installed with SQL SERVER 2005 Ent Ed.on one of its clusters(3 clusters in HA ) .Its a MOSS 2007 db server with close to 40 content db’s and the max sizing upto 70 gb.The SQL OS(64 bit) has 4 vcpu’s,32gb ram.SQL min and max setting are 1 gb and 12 gb.VM reservation is 16gb.Lock pages in memory is enabled and large pages support is also enabled.As I read from the errorlog the sql is using dynamic allocation of memory on boot.SQL is the only app installed on the guest OS .What i would like to know is ,how much more can the max memory setting be increased on the sql server without paging file to disk .During peak periods/daily maintenance hours the perfmon counters indicate more memory could be added (there are other problems with disk latency also).Can it be made in sync with the VM ‘s reservation of 16gb .Please advice.
Unfortunately this is beyond the scope of something I can answer in a blog comment. You can email me at brento@brentozar.com and we can talk about a consulting engagement if you’re interested though.