Baseline SQLServer with SQLMonitor v1.3.0
|I have been using SQLMonitor extensively for monitoring & performance tuning of my SQLServers. To make it more and more useful, I have added more functionalities to the tool in version v1.3.0.
Below are some enhancements made in release v1.3.0 –
- Vertically partitioned table
dbo.resource_consumption
into 2 tables keeping sql_text in a separate table.- This helps in creating efficient XEvents Trend dashboards.
- Capture sp_BlitzIndex in mode 0,1,2,4.
- Added more parameters in the Install-SQLMonitor function to add more flexibility in install/upgrade.
- Parameter
OnlySteps
– Specific Steps to be executed - Parameter
PreQuery
– TSQL Query to execute before Install-SQLMonitor steps - Parameter
PostQuery
– TSQL Query to execute after Install-SQLMonitor steps - Parameter
FirstResponderKitZipFile
– Zip file of FirstResponder Kit to use. Required as sometime Install-DbaFirstResponderKit does not install the latest available version.
- Parameter
- Some bug fixes in the deployment of SQLMonitor on the Central Server.
Some screenshots from new dashboards –
![](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2022/12/2022-12-23_16-36.png?resize=1024%2C468&ssl=1)
![](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2022/12/2022-12-23_16-36_2.png?resize=1024%2C375&ssl=1)
![](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2022/12/2022-12-23_16-36_3.png?resize=1024%2C379&ssl=1)
![](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2022/12/2022-12-23_16-36_4.png?resize=1024%2C504&ssl=1)
![](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2022/12/2022-12-23_16-352.png?resize=1024%2C244&ssl=1)
![](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2022/12/WhatsApp-Image-2022-12-21-at-6.57.11-dM.jpeg?resize=1024%2C470&ssl=1)
![](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2022/12/WhatsApp-Image-2022-12-21-at-6.57.11-PM.jpeg?resize=1024%2C470&ssl=1)
![](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2022/12/WhatsApp-Image-2022-12-21-at-6.57.11-qPM.jpeg?resize=1024%2C446&ssl=1)
I hope this would help SQLServer professionals looking to baseline their SQLServers.
One Comment