I just checked the live environment and those figures are similar.. So that doesn't seem to be it.
Possible, but I think it has only happened since I did the reindex. I got a list of the tables, it seems blobfield is taking up the most. BlobField...
I have tried the dbcc shrinkdatabase. How do I determine what the data vs growth is? All I really know is in our live environment it is 42gig the...
Hi all, I am hoping to get some assistance with a .mdf file that has recently grown unexpectedly.It is a DMS database in a Test environment. (The...
Hi all, ok i've applied the SP4 and hotfix mentioned. I also found that a user was running something against the filestore for the db and indexing...
Thats correct, SQL server 2000 enterprise. I'll apply SP4 and fix 2040 this weekend. It is a dedicated SQL server but its a pretty open environment...
I should also mention that in perfmon the page file % used is averaging at 0.7% Avaliable bytes is around 2.5gb. That seems the concern that there is...
It's currently on SP1. I rebooted the SQL server last night hoping that might bring it back down, as it never used to be that high. But it's straight...
Thanks for the links to read, i'll go through each of them. The server has 8gig of ram, SQL server is configured to use 7gb, but i've noticed that it...
Hi all, i've recently taken over a role of managing a SQL server. So am new to it and trying to get on top of it all. The first objective is...
Separate names with a comma.
