4.6 view server running status through Logs
SQLServer 2005 records some system events and custom events to SQL Server error logs and Windows application logs. Both types of logs are automatically marked with time.
4.6.1 view the server running
Common logs for diagnosing SQL Server problems
There are two main:
(1) Windows Event Log
(2) SQL Server ErrorLog
1, Windows Event Log event logs
As a windows open and Managed service program, Windows logs information about the startup, normal
Here are two main:(1) Windows Event Log(2) SQL Server errorlog1. Windows Event LogAs a windows open and Managed service program, Windows logs in its own syslog system logSQL Server This service start, normal shutdown, abnormal shutdown and other
When we create a database, for example, the default way to create a DB Testdb,sqlserver automatically helps us build the following two database files.
These two data files are real operating system files, one of which is called row data files,
Commonly used logs for SQL Server diagnosis: (1) Windows event log (2) SQLSERVERErrorLog1. Windows event log EventLog is used as a service program enabled and managed by Windows, windows records the startup, normal shutdown, and abnormal shutdown of
Common logs used to diagnose SQLSERVER Problems
There are two main points:
(1) Windows Event Log
(2) SQLSERVER ErrorLog
1. Windows Event Log
As a service program enabled and managed by Windows, Windows records the startup, normal shutdown, and
Commonly used logs for SQL Server diagnosis: (1) Windows event log (2) SQLSERVERErrorLog1. Windows event log EventLog is used as a service program enabled and managed by Windows, windows records the startup, normal shutdown, and abnormal shutdown of
This is different from the previous two demo, this demo basically retains the system default to those permissions group unchanged, keep the original flavor, so as not to cancel improper cause inexplicable error.
After seeing this demo, the previous "
Welcome to the Linux community forum and interact with 2 million technical staff to enter deeplin11.6. Search for all the mdbtools packages in the Software Center for installation. There should be four, one basic package and one devel package, A lib
Common Eclipse Plug-ins in the development process, sorted alphabetically:
(1) amaterasumlIntroduction: Eclipse's UML Plug-in, support UML activity diagram, Class diagram, sequence graph, UseCase diagram, etc. support for import and export between
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.