July 28, 2023 at 8:57 am
Hi, I wanted to ask: I have many servers in my company and those server is in different instances and computers. Now, I want to collect info such as disk usage and so on and view the info from all the servers in one place. I have choose to used Data Collector, but I can only view the info in the server I check the report. It is possible I can view the report from all servers in one place instead of in one server?
July 28, 2023 at 12:35 pm
Honestly, look to a 3rd party monitoring solution.
Up front, being clear and open, I work for Redgate who makes a monitoring tool.
However, what you're trying for just isn't available, out of the box, in SQL Server. If you really want to do this, you're either going to have to build it all yourself, or have someone else do it for you. I strongly recommend you get someone else to do it and then you can focus on the real issues in your systems.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 1, 2023 at 3:47 pm
I agree with Grant. Thought that datacollector was obsolete.
A monitoring tool or DIY .
For DIY you may experiment with dbatools powershell module.
August 1, 2023 at 6:28 pm
And Extended Events.
Total agreement on DBATools.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 1, 2023 at 10:21 am
This was removed by the editor as SPAM
September 1, 2023 at 10:21 am
This was removed by the editor as SPAM
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply