April 17, 2008 at 9:07 am
Hi All,
Could some one help me out with this question
How would one be able to identify the commit rate on a SQLServer ?
Thanks a ton
Hassan
April 20, 2008 at 8:40 pm
The commit process is an almost organic process - it depends upon so many factors that it is almost easier to say that SQL commits when it feels it needs to. Can I ask why you need to know this information?
- Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford
April 21, 2008 at 6:39 am
Shamsul (4/17/2008)
Hi All,Could some one help me out with this question
How would one be able to identify the commit rate on a SQLServer ?
Thanks a ton
Hassan
Commit depends on the checkpoint command, whenever a checkpoint issued the committed transactions will be written to disk. You can check the below events which caused checkpoint to occur.
The active portion of the log exceeds the size that the server could recover in the amount of time specified in the recovery interval server configuration option.
The log becomes 70 percent full, and the database is in log-truncate mode.
A database is in log truncate mode when both these conditions are TRUE: the database is using the Simple recovery model, and, after execution of the last BACKUP DATABASE statement that referenced the database, one of the following events occurs:
A minimally logged operation is performed in the database, such as a minimally logged bulk copy operation or a minimally logged WRITETEXT statement is executed.
An ALTER DATABASE statement is executed that adds or deletes a file in the database.
A BACKUP LOG statement referencing the database is executed with either the NO_LOG or TRUNCATE_ONLY clauses.
Regards..Vidhya Sagar
SQL-Articles
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply