The most recent content from our members.
What are DPA's capabilities for monitoring and troubleshooting when [tempdb] runs out of space? Can DPA... * Identify SPIDs/transactions consuming the most space in [tempdb]? * Identify related SQL statements of SPIDs/transactions? * Identify [tempdb] file space usage (size, allocated size, unallocated size, version store…
Hi, I am trying to create a monitor for all the SQL server DBs we have to alert if different SQL DB options are ON/OFF. Like if the auto create statistics option is OFF, it should raise an alert. I can easily setup a monitor using simple SQL as: SELECT COUNT(*) FROM sys.databases WHERE is_auto_create_stats_on = 0; Then…
Dear All I'm fairly new in the DPA world and therefore it could be that I missed the function I'm looking for. If I create a new alert ( "Alerts" -> "Manage Alerts" -> "Create Alert" ) I have to assign it to databases instances. This would be a SQL Server instance in my case. Is there a possibility to assign the alert to a…
I am using template from https://www.andersrodland.com/working-with-odbc-connections-in-powershell/ $Error.Clear(); function Get-ODBC-Data{ param( [string]$query=$('select count(*) from [master].[sys].[table_name]'), [string]$username='db username', [string]$password='db password' ) $conn = New-Object…
It looks like you're new here. Sign in or register to get started.