Are you performing all of the regular maintenance you should on your servers?
Do you not run CHECKDB because "it takes too long"? How about Index Maintenance - does that take too long?
Do you really have the appropriate backups in place?
Do you have benchmark numbers in place to compare when your server is "slow
Come discuss the answers to these and other questions - we will discuss the free Maintenance Solution scripted tools from Ola Hallengren and how they can help you fix these and other problems with a little easy coding you can do yourself. We will also discuss other tips and tricks to help you maintain and troubleshoot your SQL Server instances.
I’m a forty-something Microsoft SQL Server DBA of 15+ years, a devoted husband, and a father of three young boys. I have been a DBA at a public university, at a major bank, at a healthcare system, and I now work as a remote DBA with customers across the United States. I write and speak primarily about the tips and tricks that I discover along my SQL Server journey.
I just received confirmation I will be speaking at SQL Saturday 307 in Iowa City on June 7th!
I will be giving an updated version of my Ola Hallengren Maintenance Solution talk that I have given at a few previous SQL Saturdays, re-titled "Are You Maintaining Your SQL Servers?"
SQL Saturdays are awesome training and networking experiences - the full schedule hasn't yet been published but there were multiple Microsoft MVP's on the submissions list. For only a $10 lunch fee you can spend the day learning about SQL Server and networking with your peers.
Register now and I hope to see you there!