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 |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2009-11-11 : 18:52:34
|
| Can Anyone guide me as to how to check the Data file growth over the period of time.How to check Which are the transactions causing uneven growth?Thanks all. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-12 : 01:20:00
|
Very nice Tara. That reminds me that my Nov issue didn't come yet  |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2009-11-17 : 18:16:32
|
| Thanks Tara.Do I need to execute the CLR related in each of my servers prior to making this executed.Do I need execute from my development server on securing connections to my production links? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-11-17 : 20:12:02
|
| 1. No, you just need to create the CLR object on one central system and then you call the object on that central system for each of the systems you want to track. I store the systems I want to track into a table and then loop through that table for each call. I believe I show this in the blog.2. It can be created on any one system that has access to all of the systems you want to track.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
|
|
|
Data File Grow