Shrink file odd behavior

Question

Shrink file odd behavior

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

ben.rosato SSCommitted Points: 1929 More actions · Answer 1

Tim Walker (4/8/2009)
You can find out when it expanded by looking in the ..\Microsoft SQL Server\MSSQL.1\MSSQL\LOG directory. By default SQL creates trace files in there and one of the things traced is the expand event. You should be able to use this to find out which process expanded it.
Is your auto expand parameter for the file also set to 1GB? If so, you could try a smaller value to get more idea what is going on.

Nope, 100 MB for auto grow.

Tim Walker. SSCertifiable Points: 5173 More actions · Answer 2

Sorry just reread your previous posts and you are expanding by 100MB. Why not change this to 99MB so it can't regrow to exactly the same size? This eliminates the fact that it somefow regresses to where it was.

.

ben.rosato SSCommitted Points: 1929 More actions · Answer 3

Tim Walker (4/8/2009)
Sorry just reread your previous posts and you are expanding by 100MB. Why not change this to 99MB so it can't regrow to exactly the same size? This eliminates the fact that it somefow regresses to where it was.

Good idea.