question

Jim B avatar image
Jim B asked

model database transaction log growth- is that normal?

My SQL Server 2005 model database recently showed an alert from my monitoring software that the transaction log was at 99%. It's set to autogrow but what concerns me is that my understanding is that model is simply the default schema for a database. I can't recall ever seeing model grow on any other systems I have. If that's the case what should I look at to find out what's changed? Should I be concerned at all?

sql-server-2005administrationmonitoringsystem-databases
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
CirqueDeSQLeil avatar image
CirqueDeSQLeil answered

Sounds like somebody is referencing that database by mistake. model should not grow.

To find out what is causing it, try the following article:

http://www.sqlservercentral.com/articles/Log+growth/69476/

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Absolutely. I'd be freaked if I saw changes to model that weren't coming from me or another dba.
1 Like 1 ·
Matt Whitfield avatar image
Matt Whitfield answered

First, take a look at how big the log is. 99% of 1MB isn't big at all. If your log has grown to just under a megabyte in 5 years, then I would not be concerned.

So, just make sure you're chasing something worth chasing.

3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
+1 - wise words. make sure you actually have a problem to resolve
0 Likes 0 ·
Jim B avatar image Jim B commented ·
should model change at all?
0 Likes 0 ·
Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
Over the lifetime of a server, with service packs and hot fixes being applied, then yes, I would expect to see changes to model...
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.