|
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?
(comments are locked)
|
|
Sounds like somebody is referencing that database by mistake. model should not grow. To find out what is causing it, try the following article: 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)
|
|
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. +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)
|
