SQL Server log over conference impact query results _mssql
Source: Internet
Author: User
A few days ago found that the site's query a bit abnormal, in general, will first query the contents of a directory, click a table of contents will be queried after the level two directory. Until the bottom of the query to the file. But these days found that the query speed is very slow, and the query is not a level of directory, but directly show the bottom of the file, the amount of data displayed there are problems.
At first it was thought that the site was black, because the site has not been modified, so it should not be the problem of the site itself.
On the server for a long time, nothing has been found out.
Later to see the web site procedures, read for a long time, also did not see any problems.
Then went to see the database, read for a long time, also did not see any problems.
Finally accidentally see the database log file is very large, a few g, I thought it is not because of this problem?
After you have made a log backup of SQL Server, truncate the log, compress the database, and then visit the Web site. OK, everything's fine.
I did not think the SQL Server log too large will affect the results of the query Ah!
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.