December 14, 2010 at 7:56 am
If a DB log is shrinked, When a SELECT query is being run on a table, would it have a negative effect/impact on the query being run?
December 14, 2010 at 8:05 am
If you specifically only shrink the log files (not the data files),
and that your select is really a simple single step select and not a whole business process then no it won't affect performance either way. If the select actually updates or insert in permanent tables, then there's a good chance the process will have to wait for the file to grow which can take quite some time of a very busy system. And in the long run causes file system fragmentation where there's little you can do about other than starting from scratch.
However 99% of the time, when you shrink the log it'll grow right back to where it was. It's only a question of when. Kind of like going on a diet. It looks like a good plan but it rarely works out the way you planned it!
:hehe:
December 14, 2010 at 8:14 am
Thanks for the reply. Yes, its only a SELECT and does not include any Update/Insert.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply