How can we help you today? How can we help you today?

Uninstall SQL monitor

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
Sjef
0

Comments

5 comments

  • 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!


    Jessica R
    0
  • 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


    Sjef
    0
  • 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!
    Jessica R
    0
  • 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

    Sjef
    0
  • Jessica R
    Glad to hear that, Gerard! :) Thanks for the update.
    Jessica R
    0

Add comment

Please sign in to leave a comment.