How do you change the address through the GUI without having to remove mirroring for the databases, by using the Configure Security route does not give that option.

Also with the...

Thanks Gail, is there any way of monitoring what is actually using this non-buffer memory though as it does seem excessive at over 6 Gb. From what i've read...

Really strange.....the server (test server) was restored to a point in time from a cpl of weeks ago for another reason. I then decided to take the folllowing steps...

Durai,

Here is the list of top 5 tables from the report, i have exported to excel and pasted in here so hope you can make sense of it. I...

Jason, done a DBCC ShrinkDatabase and it still thinks there's just over 6GB to the database. The view that the stored proc uses just sits ontop of the table,...

Hi Markus,

I have rebuilt all indexes on msdb database and still no change. symail_mailitems is still telling me it is the largest table at 6,439,200 KB the next largest...

Thank you both for your replies. I had already reindexed the primary key on this table to no avail.

I have run the reindex again though, below is the results...

Sorry to hijack this thread but I am trying to clear out the sysmail_mailitems table myself on a SQL 2005 SP4 instance using the sysmail_delete_mailitems_sp procedure and leaving 30 days...

Thanks, I do verify the backups anyway but I thought that was just to check it was a complete backup and not if corruption existed.

This leads me to think more...

As for profiler, to trace any long running transactions I tend to remove the Security Audit and Sessions Event Classes and just trace

Stored Procedures - RPC:Completed

TSQL - SQL:BatchCompleted

Then...

I would imagine there are some transactions running on your system that are making tempdb grow. These could be creating alot of temporary tables or running lots of cursors...

Thanks Wayne, i'd imagine it would be the same process for SQL 2000 but do you have to initialize the disk and create a new resource on the other node...

I had this error recently due to a failed disk in the SAN that was part of the RAID group the database existed on. Disk was swapped out and...

Beth, thanks for taking the time out to post this script.

I shall look at adapting it for my environment.

Thanks to both dma-669038 and bethrich for your comments as well.

I really want to stay away from switching back to simple model due to not wanting to break the tran...