sql log analyzer

In the use of the process, we often encounter a very large database log, here are two ways to deal with ... Method One In general, the contraction of the SQL database does not greatly reduce the size of the database, its primary role is to shrink the log size, you should do this periodically to avoid the database log

Tags: mysql DML locatorRecent online data inexplicable lost data, so the SQL location, the location of the data lost on the line, and finally targeted to a specific development program.Audit log: Record all the information of the database, there will be a huge log, and the parameters set audit log size, audit

Analysis of MySQL Slow log is the operation of the work, not less. To quickly locate slow SQL, and to optimize SQL after discovery and to modify the business, ensure that the database works stably and efficiently. Here is my work to solve the idea ...1. View local database slow log files first650) this.width=650; "src=

Tags: write generated bsp MySQL col alt units should be two kinds ofInput command:show variables like ' slow% ' You can find that Slow_query_log is OFF (default), indicating that the slow query log is not turned on Slow_query_log_file for slow query log file There are two ways to turn on the slow query log Method One: Temporarily open Set Global slow_query_log

explain the operation method, as to the principle, does not belong to the scope of this article, and I believe that when the wrong operation, it is estimated that no one will see the principle. steps: (1), check the recovery model of the database, Or use a script check: [SQL] view plaincopyprint? SELECT Recovery_model,recovery_model_desc From sys.databases WHERE name =' AdventureWorks ' The results are as follows: Ens

Method One In general, the contraction of the SQL database does not greatly reduce the size of the database, its primary role is to shrink the log size, you should do this periodically to avoid the database log too large 1, set the database mode to Simple mode: Open SQL Enterprise Manager, in the console root in turn

Tags: SQL log shrinking SQL auto-shrinking SQL auto-redundancySQL log shrinking in full modedue to the full mode SQL logs are continuously growing, so the method of shrinking the log do

Tags: style ext color width int setSQL Servercursors are generally used to traverse tables, andSQL Server can easily loop through cursors to implement SQL Server traversal records in tables. However, cursors are not recommended for actual development. We know that you can also implement SQL Server traversal tables with temporary tables or table variables, etc.The following example uses table variables to im

Original: Unable to use SQL login to login to SQL Server-' Password did not match 'Originating From: http://blogs.msdn.com/b/apgcdsd/archive/2011/02/01/sql-login-sql-server-password-did-not-match.aspxProblem Description: In Management Studio on a single machine, SQL login is

Tags: other accounts http input password engine enable settings Lex view A small problem in the process of adding a database to the net project today is that the use of SQL Server Authentication has not been successful, and after some debugging, the problem is finally resolved. To sign in to SQL Server 2008 using the SA account, follow these steps: 1. First turn on the computer, open

Tags: run right-click Database PNG default transaction file log file LLBObjectiveNext we end up with the last few sections of the SQL Server Basic series, and then we'll talk about SQL Server performance tuning, and we'll get to the topic.SQL Server transactions affect local variablesWhat does a transaction have to do with a variable, in other words, when we roll

This is the time to read about recovering data through logs and point-in-time in SQL Server. Also looked at some online examples to see how to recover data through the log. Prerequisites: Database recovery to a non simple mode, remove automatic shutdown and auto shrink two options If this is a simple pattern: a statement like the one below will not be logged in the l