DBI-B220 – Introduction to SQL Server Management for the Non-DBA
A very interesting and entertaining session to round off Tuesday. This covered the things IT Pros need to do when they need to run SQL Server- backups, restores, checking for corruption, and more.
Here are my 5 key points from the session. This was definitely one of those sessions which I could have listed many more from!
- Keep the number of TempDB files down. 8 is a good number, and set growth to 1GB increments
- Corruption Will Happen. Check for it. Deal with it.
- Backup regularly. Try a daily full backup and transactional backups every 10-15 minutes for starters.
- Good Indexing can speed up your queries. Too much slows down your iNSERT/UPDATE/DELETE tasks
- Keep your statistics up to date