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, 2010 at 10:06 PM in Default

avatar image

Jim B
102 1 3 3

(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, 2010 at 10:35 PM

avatar image

CirqueDeSQLeil
5.5k 11 13 20

Absolutely. I'd be freaked if I saw changes to model that weren't coming from me or another dba.

Apr 29, 2010 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, 2010 at 04:55 AM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

  • wise words. make sure you actually have a problem to resolve

Apr 29, 2010 at 05:39 AM Fatherjack ♦♦

should model change at all?

Apr 30, 2010 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, 2010 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.

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:

x2017
x131
x33
x25

asked: Apr 28, 2010 at 10:06 PM

Seen: 2831 times

Last Updated: Apr 29, 2010 at 04:30 AM

Copyright 2016 Redgate Software. Privacy Policy