I am working on a project where i need to display the database mssql server's performance metrics for example memory consumed/free, storage free space etc. I have researched for this purpose and one thing came up was DOGSTATSD.
我正在开发一个项目,我需要显示数据库mssql服务器的性能指标,例如内存消耗/免费,存储空闲空间等。我已经研究过这个目的,有一件事情是DOGSTATSD。
Datadog provides the library for .net project to get custom metrics but that was not the solution for me because the metrics works on datadog website. I have to display the all (in graph or whatever suited) data, received from MSSQL SERVER. There will be multiple servers/instances.
Datadog为.net项目提供了库以获取自定义指标,但这对我来说不是解决方案,因为指标适用于datadog网站。我必须显示从MSSQL SERVER收到的所有(在图形中或任何适合的)数据。将有多个服务器/实例。
Is there a way to do that, our WebApp connected with multiple databases and we receive/display information.
有没有办法做到这一点,我们的WebApp与多个数据库连接,我们接收/显示信息。
I cannot use already available tools for the insights.
我不能使用已有的工具来获得洞察力。
1 个解决方案
#1
1
You can easily get all needed data via querying dmv and other resources inside SQL Server. Good start is here.
您可以通过查询SQL Server中的dmv和其他资源轻松获取所有需要的数据。好的开始在这里。
#1
1
You can easily get all needed data via querying dmv and other resources inside SQL Server. Good start is here.
您可以通过查询SQL Server中的dmv和其他资源轻松获取所有需要的数据。好的开始在这里。