December 23, 2024 at 5:46 pm
Hello experts,
I got a report from an application owner of degraded performance for an application.
To paraphrase: The unused table space is quite large when compared to the actual data space used. Per the vendor, this would impact performance.
Has anyone ever heard of unused table space causing performance issues? I haven't. In addition, if this is a real issue, is there a way to shrink unused table space, as opposed to shrinking the entire database (which I have often heard is not a good idea anyway)?
Thanks for any help or information that can allow me to resolve this issue.
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
December 23, 2024 at 7:17 pm
It depends. If the unused space is significant and is embedded in pages that are being read, i.e. contain live data, then it could slow down access (somewhat) because more pages would need read.
IF you have this situation, then rebuilding the table indexes will re-compact the space. Be sure to specify a fillfactor lower than 100 if you need to make changes to rows that will data. If you're unsure, try using FILLFACTOR=95 when you rebuild the indexes.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply