To identify the performance of sqlserver between 1 month of different years.

Question

To identify the performance of sqlserver between 1 month of different years.

SVA 116

Hi,
How can I identify the performance load of SQL Server between 2 period of different years, Any script to calculate the I/O load and performance of SQL Server. I s there any tools to identify the performance and I/O load on SQL Server between 2 periods.

Seeya Xi-MSFT 16,661 Reputation points

2022-07-08T07:25:18.747+00:00

Hi @ShanlyV-5349,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya
SVA 116 Reputation points

2022-07-12T08:32:01.807+00:00

Thanks for the answer. I would like to know which 3rd party tool is best for performance and health monitoring of SQL Server remotely.

Accepted answer

3 additional answers

Your answer

Seeya Xi-MSFT 16,661 Reputation points

2022-07-08T07:25:18.747+00:00

Hi @ShanlyV-5349,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya
SVA 116 Reputation points

2022-07-12T08:32:01.807+00:00

Thanks for the answer. I would like to know which 3rd party tool is best for performance and health monitoring of SQL Server remotely.

Answer 1

Hi @ShanlyV-5349 ,

Welcome to Microsoft Q&A!
In order to monitor the query performance, we can use the following tools. Of course, there must be some that I have not listed.

Query Store
Dynamic Management Views and Functions (DMV)
Extended Events
Performance Monitor
Activity Monitor and Data Collection
3rd party SQL Server Monitoring tools
SQL Server Management Studio (SSMS) reports
Hope these would give some help.

Best regards,
Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Tom Phillips 17,776

SQL Server does not log that information. You would need a 3rd party app. There are many, SCOM, Solarwinds, etc which will keep a log over time specifically for that purpose..

Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator

2022-07-06T20:32:17.04+00:00

That's not entirely correct, as you track quite much of that information with Query Store. However, you would still need the skills or the tools to collect the information. And since Query Store is per database, you need to consolidate the data if you have many databases. So in the end a 3rd party tool that works from DMVs may be a better option.

Tools that comes to mind are Red Gate's SQLMonitor and the SolarWinds portfolio. Quest is also in this market.

Answer 3

Olaf Helper 47,541

How can I identify the performance load of SQL Server between 2 period of different years,

How do you define "performance" in context of SQL Server? Have you a monitoring software running?

Answer 4

Hi,

I’d like to add a few thoughts to the valuable suggestions already shared. A number of great tools have been mentioned, but I’d like to highlight what worked well for me when facing a similar challenge.

In my case, I combined native features in SSMS (such as Activity Monitor and built-in reports) with third-party solutions from dbForge. Their tools helped me analyze I/O load and performance patterns across different time periods, especially when comparing usage between two separate years.

You might find the following resources useful:

These resources helped me gather metrics on CPU, memory, disk I/O, and query performance — and visualize trends across historical data snapshots.

Hope this helps someone facing a similar task.

Best regards,
Don

Share via

To identify the performance of sqlserver between 1 month of different years.

3 additional answers

Your answer