We are using SQL Server 2008 as our database server. Recently we came to know, by using a 3rd party tool, that the response time of our database server is increasing at a specific time for example at night 1AM to 4AM. That 3rd party tool provides no information about the activity which is causing this.
We are using SQL Server 2008.
We have scheduled some SQL Jobs but their execution time is different; not in the range where the response time is high.
I hope my question is clear enough if not please let me know.