x

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?

more ▼

asked Apr 28 '10 at 10:06 PM in Default

Jim B gravatar image

Jim B
102 1 1 2

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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/

more ▼

answered Apr 28 '10 at 10:35 PM

CirqueDeSQLeil gravatar image

CirqueDeSQLeil
4k 10 11 15

Absolutely. I'd be freaked if I saw changes to model that weren't coming from me or another dba.
Apr 29 '10 at 08:13 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Apr 29 '10 at 04:55 AM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.4k 61 65 87

+1 - wise words. make sure you actually have a problem to resolve
Apr 29 '10 at 05:39 AM Fatherjack ♦♦
should model change at all?
Apr 30 '10 at 03:55 PM Jim B
Over the lifetime of a server, with service packs and hot fixes being applied, then yes, I would expect to see changes to model...
Apr 30 '10 at 04:29 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1933
x124
x18
x17

asked: Apr 28 '10 at 10:06 PM

Seen: 2228 times

Last Updated: Apr 29 '10 at 04:30 AM