Uninstall SQL monitor

Sjef

Hi All,

I tried to unistall SQL monitor but it's not completly removed. A task is staying in the background. After unistall I keep on having one constantly waiting task. When running this Query:

SELECT OBJECT_NAME(ind.OBJECT_ID) AS TableName,

ind.name AS IndexName, indexstats.index_type_desc AS IndexType,

indexstats.avg_fragmentation_in_percent

FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) indexstats

INNER JOIN sys.indexes ind

ON ind.object_id = indexstats.object_id

AND ind.index_id = indexstats.index_id

WHERE indexstats.avg_fragmentation_in_percent > 35

ORDER BY indexstats.avg_fragmentation_in_percent DESC

I get this data:

TableName IndexName IndexType avg_fragmentation_in_percent

redgate_sqlmonitor_topqueries_b_sql01_sql01.(local) redgate_sqlmonitor_topqueries_b_index_sql01_sql01.(local) CLUSTERED INDEX 77.7777777777778

redgate_sqlmonitor_topqueries_a_sql01_sql01.(local) redgate_sqlmonitor_topqueries_a_index_sql01_sql01.(local) CLUSTERED INDEX 71.4285714285714

Showing 2 Red Gate processes that keep on running.

I re-installed and removed again with the same results. 

What do I need to do to get rid of these processes ?

Thanks for your time !!

Regards,
Sjef

Jessica R

Hi @Sjef ,

Thanks for your post!

I believe the results from the query on sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) aren't exactly running tasks, but are just stats on those two tables which are part of RedgateMonitor, the repository database.

The uninstall doesn't delete the database (in case you want to reinstall at some point and keep the same history), but to remove any trace of it, you'll just need to drop the RedgateMonitor database from SSMS. Can you kindly give this a try?

Hope that helps!

Sjef

Thanks Jessica,

I see I did not provide all the info in my last post. Missing: The Query was executed on the tempDB.

I removed the RedGate database. The running task is still there though. I see the two mentioned tables from the Query in TempDb\Tables\

Can I safely remove these two from the TempDb ?

After that I will first reboot the SQL server and see what happens then.

Cheers,
Sjef

Jessica R

Hi @Sjef!

Yes, deleting the two tables from TempDb is safe to do.

Please let us know if any other questions come up! 

Sjef

Thanks Jessica,

Everything is clean now. Server has been rebooted. I keep on having the running task, but I'm convinced it is not related to SQL monitor. I will have to dig deeper into this.

Thanks for the support !! And you can close this thread.

Cheers,
Gerard

Jessica R

Glad to hear that, Gerard! Thanks for the update.