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

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

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

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

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

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

+1 - wise words. make sure you actually have a problem to resolve
0 Likes 0 ·
should model change at all?
0 Likes 0 ·
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.