Comments
Sort by recent activity
Do the "Select" drop down like you're going to clear all of the alerts, and choose ALL. Once you do that, you will see the option. [image] / comments
Do the "Select" drop down like you're going to clear all of the alerts, and choose ALL. Once you do that, you will see the option.
I'm an idiot. There is an option to check all alerts (not just the ones showing) that was right in front of my face the entire time. I'm good now. :oops: / comments
I'm an idiot. There is an option to check all alerts (not just the ones showing) that was right in front of my face the entire time. I'm good now. :oops:
I had to have the SAN admin give me another 100GB since the tempdb.ldf file grew to 70 GB, and it did eventually free up about 60 GB. The db shrink was taking forever, though, so I decided to just drop the database and let it create a new one. Setup is really simple, so it didn't take long to reconfigure things. I made sure to set the data purge at 2-months retention this time.
Thx / comments
I had to have the SAN admin give me another 100GB since the tempdb.ldf file grew to 70 GB, and it did eventually free up about 60 GB. The db shrink was taking forever, though, so I decided to just...
The database server was crawling when I got in this morning, and users were complaining about not being able to use apps that had databases on that server. I did receive an email from RG Support with a link about my issue, but it's too late now unfortunately. www.red-gate.com/supportcenter/Content? ... %20Monitor
The database was created on 02/08/2011, and is currently monitoring 8 servers and 8 instances. I should have set a purge policy long ago to avoid all this. A reboot seems to have cleared things up. I also got more memory and 2 additional procs added to my server -- bonus!
I'm going to let it run for a bit, then revisit the purge properties later. I do have 1659MB of free space now (out of 72064 MB) on the SQL Monitor MDF file. I only had about 20MB free before the purge started.
P.S. I still love SQL Monitor! / comments
The database server was crawling when I got in this morning, and users were complaining about not being able to use apps that had databases on that server. I did receive an email from RG Support w...
Well, I upgraded both instances and can now see one. Looks like the upgrade helped, but I think I'm also having a WiFi issue. Thanks for your help, Chris! / comments
Well, I upgraded both instances and can now see one. Looks like the upgrade helped, but I think I'm also having a WiFi issue. Thanks for your help, Chris!