14,958
edits
Testing: Difference between revisions
Jump to navigation
Jump to search
m
→Database server
| Line 137: | Line 137: | ||
<pre> | <pre> | ||
[mysqld] | [mysqld] | ||
## | ## includes all SQL queries/commands | ||
# general_log = 1 | # general_log = 1 | ||
# general_log_file="general_log_file.log" | # general_log_file="general_log_file.log" | ||
| Line 152: | Line 152: | ||
==== Microsoft SQL Server ==== | ==== Microsoft SQL Server ==== | ||
* [http://expressprofiler.codeplex.com/ ExpressProfiler] | * [http://expressprofiler.codeplex.com/ ExpressProfiler] includes all SQL queries/commands | ||
* [http://msdn.microsoft.com/en-us/library/ms187109.aspx SQL Server Error Log] / [http://msdn.microsoft.com/zh-tw/library/ms187885(v=sql.105).aspx 檢視 SQL Server 錯誤記錄] "contains user-defined events and certain system events ..." quoted from [http://msdn.microsoft.com/en-us/library/ms187109.aspx SQL Server Error Log] ex: X:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG | * [http://msdn.microsoft.com/en-us/library/ms187109.aspx SQL Server Error Log] / [http://msdn.microsoft.com/zh-tw/library/ms187885(v=sql.105).aspx 檢視 SQL Server 錯誤記錄] "contains user-defined events and certain system events ..." quoted from [http://msdn.microsoft.com/en-us/library/ms187109.aspx SQL Server Error Log] ex: X:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG | ||
* [http://stackoverflow.com/questions/123781/logging-all-queries-on-a-sql-server-2008-express-database Logging ALL Queries on a SQL Server 2008 Express Database? - Stack Overflow] ''not tested'' | * [http://stackoverflow.com/questions/123781/logging-all-queries-on-a-sql-server-2008-express-database Logging ALL Queries on a SQL Server 2008 Express Database? - Stack Overflow] ''not tested'' | ||