During Comprehensive Database Performance Health Check we always go over various SQL Server properties. Lots of people do not know that there are quite a few SQL Server settings which can help us improve our SQL Server performance many folds. While I was discussing SQL Server properties, someone asked me if there are similar settings for SQL Server Agent available which users can tune.
Question: How to List All the SQL Server Jobs When Agent is Disabled?
Question: How to Schedule a Job on SQL Server?
Answer: A very old and widespread question, keep on coming back to in interviews. Let us see how to schedule a job on SQL Server.
“How come my database is only a few MBs big and I am facing performance problems?” My customer asked. I replied, “Well, this is because you are not running job using SQL Server Agent to keep your indexes in the best health.”