reasons

Question

reasons

ramyours2003

SSChampion

Points: 12268
More actions
July 16, 2013 at 7:07 am

#295552

what are the possible reasons when a query is timed out ?
what are the possible reasons for not truncating the log file ?
i have Log file of 5 GB how many VLF"s will be present ?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

ramyours2003 (7/16/2013)
what are the possible reasons when a query is timed out ?
what are the possible reasons for not truncating the log file ?
i have Log file of 5 GB how many VLF"s will be present ?

Interview questions?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

ramyours2003 SSChampion Points: 12268 More actions · Answer 2

ramyours2003

SSChampion

Points: 12268

July 16, 2013 at 7:23 am

#1632861

no just for getting answers on this.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

ramyours2003 (7/16/2013)
what are the possible reasons when a query is timed out ?

The query took longer than the application's timeout setting.

what are the possible reasons for not truncating the log file ?

There are no good reasons for not truncating the transaction log, unless you want to test what happens when the log runs out of space.

i have Log file of 5 GB how many VLF"s will be present ?

2 or more.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQLAssAS SSCertifiable Points: 7246 More actions · Answer 4

DBCC LOGINFO < this will show you the amount of VLFs you have

Luis Cazares SSC Guru Points: 183706 More actions · Answer 5

GilaMonster (7/16/2013)
ramyours2003 (7/16/2013)
what are the possible reasons for not truncating the log file ?
There are no good reasons for not truncating the transaction log, unless you want to test what happens when the log runs out of space.

What about using simple recovery model? Am I confused here?

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

Luis Cazares (7/16/2013)
What about using simple recovery model? Am I confused here?

He's asking (afaict) for reasons not to truncate the log. In simple recovery, the log is automatically truncated, so the opposite.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass