Dba.stackexchange.com

What is the best query to use to monitor a SQL Server database's …

WebStack Exchange Network. Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for …

Actived: 4 days ago

URL: https://dba.stackexchange.com/questions/712/what-is-the-best-query-to-use-to-monitor-a-sql-server-databases-status

SQL 2016 AlwaysOn Database Health Level Detection

WebI am researching SQL Server 2016 and AlwaysOn. One of the new features which sounds awesome on paper is "Database Health Level Detection". From my …

Category: Health Go Health

How check that the Oracle Database is up

WebFirst thing first: you need to know the username and password to connect to database for step 2. Check the oracle process runs: On Un*x: ps -ef|grep pmon. On …

Category: Health Go Health

How are the system health extended events files rolling over

WebI see the default system health session events within SQL Server are 5 MB each with 4 files in total. We are trying to fetch data from the system health in historical …

Category: Health Go Health

How to check history of primary node in an Availability Group

WebStack Exchange Network. Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to …

Category: Health Go Health

Availability Group how to determine last Failover time

WebStack Exchange Network. Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to …

Category: Health Go Health

Way to find when system health file is rolling over

WebIs there a way to find the events when system health extended event files are rolling over rather than manually monitoring for the events? For my medium load …

Category: Health Go Health

MySQL Data model for clinic appointment management system

WebAs a matter of course, one should use more tables if one needs more tables to maintain consistency, avoid update errors, or provide flexibility. As I see it from here, …

Category: Course Go Health

Logon failed for login due to trigger execution

WebAfter struggling with this issue for several hours I found a very simple solution to retore the connextion to my empty local database:. 1 - Open a CMD/Terminal …

Category: Health Go Health

Why Does the Transaction Log Keep Growing or Run Out of Space

WebA Shorter Answer. You probably either have a long running transaction running (Index maintenance? Big batch delete or update?) or you are in the "default" …

Category: Health Go Health

Querying system health data becomes slow as event volume …

WebI am trying to explain one of reason . Currently object_name is Non unique Clustered index.. So when data is inserted, database engine will search for empty space …

Category: Health Go Health

Incorrect process utilization from System health extended events

WebI have been recently working on understanding the data or metrics being stored in system health extended events event file. We are trying to implement the data …

Category: Health Go Health

How to remove SQL Server Error Logs

WebStack Exchange Network. Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for …

Category: Health Go Health

"Could not find stored procedure' even though the stored …

WebIn SQL Server 2008, when logged in under a Windows account, if you don't have SYSADMIN security level, when you create an object without explicitly specifying …

Category: Health Go Health