Production Database Administration

Eyes up here, kid

Free Webcast: Help! My SQL Server Maintenance is Taking Too Long!

“Time for a smoke break.” You manage growing SQL Server databases with shrinking nightly maintenance windows. You just don’t have enough time left each night to do the necessary backups, corruption checking, index maintenance, and data jobs that your users and apps want to run. Cloud storage isn’t helping the problem, either. Stop playing Tetris…
Read More

Paul White Explains Temp Table Caching 3 Ways

TempDB
1 Comment
Paul White, Debugger of SQL Server Paul White (Blog, @SQL_Kiwi) is a legendary SQL Server blogger who’s written a ton of good material. You should read all of it. You won’t, and I can say that with authority because…I don’t read it all either. It’s too much. But when your job eventually requires you to…
Read More

[Video] How Can I Measure If My Database Does More Reads Than Writes?

When someone asks you, “Is this database read-intensive or write-intensive?” you probably look at sys.dm_io_virtual_file_stats to measure the file activity – but that isn’t really correct. After all, your users run a lot of queries all day that are simply satisfied from the buffer pool. SQL Server caches your data so it doesn’t have to hit…
Read More
Menu
{"cart_token":"","hash":"","cart_data":""}