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 |
|
AlexanderSupertramp
Starting Member
1 Post |
 Posted - 2010-08-30 : 15:53:58
|
| I have my production server's data increasing very rapidly these days. The mdf files are almost increasing 50GB a week from last 2 weeks. Before that it was like 5GB a week or even less.How can I keep track of these databases?. How can I know which database is being used mostly? and which table is being populated recently with lots of data? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-08-31 : 05:50:36
|
| Tara; I found your blog post really interesting and I had this exact problem a few years ago when I worked with an ASP provider with roughly 250 instances of sql server. I never got around the security part of it and logging in to each and every server...how do you do this? I see that the connection is using integrated security but how is this handled on the individual server? Are they all in the same domain?? Domain trusts..?- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-09-01 : 03:03:48
|
| Yep, that explains it then. When I worked on this all instances belonged to different clients so I started creating some procedures using OPENROWSET and a table with specific sql server logins for each instance. I got it working in a test environment but getting it to run across vlans and different zones was a mess so the project basically got canned.- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
|
|
|
Database is increasing rapidly