Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

reasons Expand / Collapse
Author
Message
Posted Tuesday, July 16, 2013 7:07 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 5:02 AM
Points: 544, Visits: 2,098
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 ?

Post #1474110
Posted Tuesday, July 16, 2013 7:15 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, December 19, 2014 2:05 PM
Points: 13,327, Visits: 12,820
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1474114
Posted Tuesday, July 16, 2013 7:23 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 5:02 AM
Points: 544, Visits: 2,098
no just for getting answers on this.
Post #1474121
Posted Tuesday, July 16, 2013 7:37 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:55 AM
Points: 40,620, Visits: 37,087
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 2008, MVP
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

Post #1474131
Posted Tuesday, July 16, 2013 9:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 4:52 AM
Points: 297, Visits: 899
DBCC LOGINFO < this will show you the amount of VLFs you have
Post #1474189
Posted Tuesday, July 16, 2013 10:27 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 7:08 PM
Points: 4,046, Visits: 9,205
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.
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?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1474218
Posted Tuesday, July 16, 2013 10:29 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:55 AM
Points: 40,620, Visits: 37,087
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 2008, MVP
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

Post #1474220
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse