you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
- 1 Answers
- 1071 Views
- I also Faced
- E-Mail Answers
Answer / Sarvesh Kumar Kutar
The transaction log can grow excessively due to heavy write operations, long transactions, or a high level of uncommitted transactions. To fix this issue, you should optimize your database design, reduce the amount of writes by batching them together, and set appropriate transaction isolation levels. Additionally, monitor your database using performance counters, DMVs (Dynamic Management Views), and consider configuring a maintenance plan for regular transaction log backups.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to transfer data from a cursor to variables with a "fetch" statement?
What is self contained sub query?
how to get the automatic backup of the database in the sql server
What is indexing a document?
Can sql servers linked to other servers?
What is the difference between count () and rowcount ()?
Where is my database stored on the hard disk in ms sql server?
How to download and install sql server 2005 books online?
What is the difference between stored procedure and functions?
How many types of objects are there?
Does index slows down insert statements?
What Is The Difference Between Primary Key & Super Key
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
