I also have three non-Production databases Training, Development and Test which reside together on a separate DB Server. I have a 1.2TB database occupying roughly 1.5TB of diskspace on Production across 8 Data and 8 Index files. So, I have got the scenario in which I need to find a way to automate SHRINKFILE, or at least, to automate the effect.
#Shrinkit cast decoration free#
Contact us for a free 30-minute sales consultation. SQL Critical Care® – Don’t have time to learn the hard way? We’re here to help with our quick, easy day process that gets to the root cause of your database health and performance pains. We start at backups and work our way up to performance tuning. Our Free 6-Month DBA Training Plan – Every Wednesday, you get an email with our favorite free SQL Server training resources.
#Shrinkit cast decoration plus#
sp_Blitz® gives you a prioritized list of health and performance issues, plus gives you URLs for more details about each issue. Sp_Blitz®: Free SQL Server Health Check – You’ve inherited a SQL Server from somebody, and you have no idea why it’s slow. Learn More About Why Your SQL Server is Slow
#Shrinkit cast decoration how to#
If you still think you want to shrink a database, check out how to shrink a database in 4 easy steps. This kind of advice shouldn’t clear any kind of SQL Server editorial team either.Ĭoming next month: “How to Reduce Your Backup Times with the Truncate Table Command!” I feel bad going nuclear on this article, but I’m not just venting about the author. Tripp – “8 Steps to Better Transaction Log Throughput” Mike Walsh’s followup – “Shrinking is a Popular Topic”.Mike Walsh – “Don’t Touch That Shrink Button”.Paul Randal – “Why You Should Not Shrink Your Data Files”.
Instead, I’m going to point to half a dozen posts explaining why this advice is just a flat out epic fail: I’m not going to reinvent the wheel by telling you why. And so help me, if you find yourself shrinking databases so often that you have to automate it, you need to cut up your DBA card and reconsider your choice of career. Empty files don’t take longer to back up. You don’t get bonused based on the amount of free space on your drives. Your disk drive space is for files, not for ornamentation. It’s an unbelievably, disgustingly, repulsively bad idea.
To make matters worse, this particular article is by a Microsoft DBA and doesn’t include a single word about the problems involved with shrinking your database files.ĭon’t shrink your database files just to free up drive space. SQL Server Magazine just tweeted about their latest article, a reader-submitted solution on how to shrink your database files with ease. I had sworn to myself that if I saw one more helpful article about how to shrink your SQL Server database files with DBCC SHRINKFILE or how to back up your log with TRUNCATE_ONLY, I was going to write a rant about it.
0 kommentar(er)
