Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
snomad
Starting Member
22 Posts |
 Posted - 2009-09-04 : 04:55:16
|
I monitor log sizes and note the %used creeping up on the model db.I'm not making any changes to model so am confused as to why there is activity. Is there some system (non user) activity that uses model?Not at all important, just curious & google isn't forthcoming.Thanks in advance. Thank you!! |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-04 : 05:37:20
|
| How do you monitor log sizes? E.g. DBCC SQLPERF(LOGSPACE), PerfMon |
 |
|
|
snomad
Starting Member
22 Posts |
Posted - 2009-09-04 : 05:55:07
|
| i just use dbcc sqlperfThank you!! |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-04 : 06:05:07
|
| The model database is used as a template when new databases are created. There isn't any other activity, usually.Is it possible you have user objects in the model database? What is the size of model? |
|
|
|
|
|
|
tran log on the model db.