कर्ता (A Worker)
There are so Many workers/Native tools within SQL server having different responsibilities...
- SQL Server Agent is responsible to run scheduled jobs and send notification.
- Configuration Manager to change default settings and restart services.
- SQL profiler to capture ongoing internal activities.
- SSMS for GUI and Query Analyser.
Additionally,
We can use windows Performance Monitor to find any performance issues Impacting SQL Server.
Best Regards
T. Amit Vaid S.
9711004147
For those who prefer to use query analyser, SQL agent services can be restarted from there as well..
ReplyDeleteBest Regards
T. Amit Vaid S.
विचार की सदा हो जय!
ReplyDelete