The most recent content from our members.
We currently use the AppInsight for SQL monitor as well as the SQL Server 2005-2008 monitor on a few. I have set the "credential type" to "Windows credential" on all AppInsight templates. It appears the SQL Server 2005-2008 monitor template doesn't have that configuration option. While the monitors are working and logging…
What is the best way to monitor SQL instances via AppInsight? Is it best to point AppInsight to the instance (clustered) or add AppInsight to each node individually?
AppInsight for SQL Permissions The minimum SQL permissions required to use AppInsight for SQL are as follows: Must be a member of the db_datareader role on the msdb system database. Must have VIEW SERVER STATE permissions. View any definition. Connect permission to Master database. Execute permission on the Xp_readerrorlog…
Is there an out of the box way to view/track individual SQL database table sizes for a SQL database that's being monitored with "AppInsight for SQL". I've seen there are ways to view the current snapshot of "Top 10 Tables by Size" for a given database, and for the database-level data file and transaction file sizes. But is…
It looks like you're new here. Sign in or register to get started.