Search all the documentation for "log files"
-commit mode, the primary replica sends log records to the secondary replica, and then waits for the secondary to receive and harden these
any transactions until it receives acknowledgement that all synchronous secondary replicas have finished hardening the commit in their lo
monitor on another machine Click the base monitor installer link to download the SQLMonitorBaseMonitorInstaller.exe file. Run the .exe fi
verify one of the .dll files used by SQL Monitor. Workaround Install the web server and the monitoring service (also called the base moni
": reconnectautomatically.gif Replace "false" with "true" for this setting, and save the file. Restart the Base Monitor. To do this, in th
log file) will be replaced by a new deadlock alert. Clicking on an instance of this deadlock alert now shows a visualization of the deadl
Database mirroring is a mechanism for achieving high availability within SQL Server. It automates the process of sending transaction logs
: Changes to custom metrics aren't immediately reflected on the custom metrics list. SRP-6875: Analysis - Total size, Data size, Log size
/sm8/release-notes-and-other-versions/sql-monitor-3-2-release-notes
By default, users log into SQL Monitor using the passwords set by the administrator. Alternatively, administrators can set SQL Monitor to
want to access SQL Monitor through a firewall, check the firewall requirements. Web service account The account should have Log on as ser
improvements Fixes SRP-10308: SQL Monitor causes a large number of DNS queries SRP-10451: Cannot retrieve log files for users who monitor
/sm8/release-notes-and-other-versions/sql-monitor-5-2-release-notes
in their log. This means no data will be lost on failover, because the primary and secondary replica databases are synchronized. However,
If you have connection problems when monitoring some of your servers, you can view logged connection errors: Go to the Configuration tab
/sm8/advanced-operations/viewing-connection-information-for-monitored-servers
categorized as an authentication error. SRP-2489: Analysis page not plotting Total Size, Data Size and Log Size graphs. SRP-2398: Invalid
/sm8/release-notes-and-other-versions/sql-monitor-2-1-release-notes
In the Account tab, under User logon name, specify the username before the @ separator. For example, if you want to log in using Administ
/sm8/troubleshooting/error-messages/user-or-group-doesn-t-exist
the monitoring service is running: Log into the machine that hosts the monitoring service. In the Start menu, type services.msc Services
/sm8/troubleshooting/error-messages/unable-to-connect-to-base-monitor
> Username or password is incorrect. The account doesn't have permission to log in to the specified SQL Server. CREATE DATABASE permission
/sm8/troubleshooting/error-messages/creating-a-data-repository-database
you install SQL Monitor, you can create a password to log in as an administrator. image2018-3-20_10-29-9.png This creates the Administrat
/sm8/configuring-sql-monitor/security-authentication-and-user-roles/managing-user-roles
, and the machines being monitored, have synchronized clock settings. If not, you may experience the issues listed below. I can't log into
/sm8/troubleshooting/unexpected-behavior/issues-caused-by-clock-skew
Active Directory Can't log in to SQL Monitor with Active Directory Error messages Error messages IIS, WMI and ASP.NET Issues with IIS, WM
RedgateMonitor. Edit the SQL Monitor configuration file to update the connection string that locates the SQL Monitor database. Navigate t
on the Log page. There is a hotfix available from Microsoft for this issue. See http://support.microsoft.com/kb/981314 http://support.mic
g Exporting the data Click exporticon.gif Export... to open or save metric data as a .csv file for the object and time range specified. Th
/sm8/analyzing-performance/analysis-graph/finding-additional-metric-information
be escalated to Log on as service (required for the account to run the Base Monitor service). Login failed for user <username> SQL Server
/sm8/troubleshooting/error-messages/connecting-to-the-data-repository
of the page. Editing credentials You may be forced to change the credentials used to log in to the Windows server on which the SQL Server