Posts
Sort by recent activity
CPU Utilisation alerts after instance boot - bug?
Hi guys.We are currently getting high CPU utilisation alerts every morning after our UAT and dev instances boot from an overnight shutdown.The issue I have with this is that the alert across all in...
SQL Monitor Powershell cmdlet issue
Hi all.I'm having trouble setting up access to SQL Monitor via Powershell. I am getting the error "Invoke-RestMethod : Invalid URI: The hostname could not be parsed."Here is what I have done to get...
Static Data - how many rows max?
HiWe are currently experimenting with including static data in our source control repos.Question is how much static data would be a realistic maximum before the pull speed is compromised?Lets say w...
Migration script causing issues...?
HiI have attempted to use a migration script on my local database to do the following:
add a column to an existing table
populate new column with a default value of zero
alter new column to be not...
SQL Monitor Alert for when SQL Monitor server goes down...?
Hi all.I have been trailing a scenario where the server running our sql monitor software goes down - hoping there'll be an alert pop up. Alas, there is no alert in sql monitor after a forced restar...
Generate data using SQL Agent job
Hi allI currently have a .sqlgen project which I would like to run automatically via a SQL Agent job.I can get a Powershell script to run correctly populating the data from a dev database to a loca...
SQL Monitor alerts on SQL alerts
I am just about to configure some SQL Server Alerts in SSMS on one of my production servers (detailed here: https://www.mssqltips.com/sqlservertip/3384/configuring-critical-sql-server-alerts/)
Is t...
Data file usage %
Hi.I noticed in the reporting section that there is a metric for log space used %. I'm trying to find a metric for the data file usage %, but cannot seem to find it. If it isn't available, this wou...