Forum Discussion
Stored Proc is running , is there anyway to see what database it is working on
Stored Proc is running , is there anyway to see what database it is working on? the script is Ola Helgren's IndexOptimization on all user databases. I tried using sql profiler but nothing usefull ca...
If it is optimizing indexes you can usually catch them running in the "Active Expensive Queries" pane in the Activity Monitor on SSMS. Each query being run to optimize will usually show up there.