How do you use cloud databases? Take the survey.
Options

Uninstall SQL monitor

SjefSjef Posts: 3 New member
in Redgate 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
Tagged:
· Share on Twitter

Answers

  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4

    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 Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


    · Share on Twitter
  • Options
    SjefSjef Posts: 3 New member
    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


    · Share on Twitter
  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4
    Hi @Sjef!

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

    Please let us know if any other questions come up! 

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


    · Share on Twitter
  • Options
    SjefSjef Posts: 3 New member
    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

    · Share on Twitter
  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4
    Glad to hear that, Gerard! :) Thanks for the update.

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


    · Share on Twitter
Sign In or Register to comment.