Click here to Skip to main content
15,849,328 members
Home / Discussions / Database
   

Database

 
GeneralRe: Join a 3rd table, in which multiple records with the same id exist, but I just need 1 of them Pin
jkirkerx14-Oct-14 10:53
professionaljkirkerx14-Oct-14 10:53 
QuestionString or binary data would be truncated. Pin
vJay Yadav6-Oct-14 23:33
professionalvJay Yadav6-Oct-14 23:33 
AnswerRe: String or binary data would be truncated. Pin
Mycroft Holmes7-Oct-14 0:09
professionalMycroft Holmes7-Oct-14 0:09 
GeneralRe: String or binary data would be truncated. Pin
vJay Yadav7-Oct-14 3:28
professionalvJay Yadav7-Oct-14 3:28 
AnswerRe: String or binary data would be truncated. Pin
Richard Deeming7-Oct-14 2:39
mveRichard Deeming7-Oct-14 2:39 
GeneralRe: String or binary data would be truncated. Pin
vJay Yadav7-Oct-14 3:28
professionalvJay Yadav7-Oct-14 3:28 
AnswerMessage Closed Pin
6-Oct-14 7:45
askbbrewer6-Oct-14 7:45 
AnswerSQL Server 2008 R2 log growth question - solved! Pin
GuyThiebaut4-Oct-14 9:28
professionalGuyThiebaut4-Oct-14 9:28 
A log file has been growing very fast from 2 gig up to 19 gig in a matter of about 4 hours.
The recovery model is set as full.
Even with backing up the transaction log file, every 30 minutes, I have found that the log file is not getting truncated.

I did notice that the file growth stopped as soon as the workday came to a close.
On running DBCC SQLPERF(LOGSPACE) I noticed that the log space was being eaten up fairly quickly. Also on running DBCC OPENTRAN I did not see any really old transactions that had not been commited

In my investigations someone mentioned that if a person was selecting a large volume of data this could make the log file grow. It is quite possible to select in the region of 9million plus rows in a select query of this database.
I was under the impression that the transaction log file only contained updates, deletes and inserts in order to be able to rebuild the database at any point in time. Having googled this I am not any the wiser.

I will run some more diagnostic tests on Monday to see if I can discover any more information if I see the log file growing rapidly again.

So my question is – would a large number of individual select commands, or a high volume of data being selected get logged to the transaction log file?

_____________________________________________
Solved - read below
_____________________________________________

It turns out that a user was running a large report which kept falling over.
They kept restarting the report.
The software is a 3rd party piece of software that appears to write results to some sort of temporary table.

I asked the user to run the report first thing this morning, when the office was very quiet.
Using DBCC SQLPERF(LOGSPACE) I then noticed the log starting to be eaten up again and when the report completed the log stopped growing.

So I think I am going to set up some sort of warning system that monitors log growth over time and alerts me when it starts ballooning as it did on Friday.
“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens


modified 6-Oct-14 8:04am.

SuggestionRe: SQL Server 2008 R2 log growth question Pin
Richard Deeming6-Oct-14 2:51
mveRichard Deeming6-Oct-14 2:51 
GeneralRe: SQL Server 2008 R2 log growth question Pin
GuyThiebaut6-Oct-14 2:58
professionalGuyThiebaut6-Oct-14 2:58 
QuestionMax throughput Microsoft SQL Server? Pin
devvvy2-Oct-14 14:05
devvvy2-Oct-14 14:05 
GeneralRe: Max throughput Microsoft SQL Server? Pin
PIEBALDconsult2-Oct-14 14:36
mvePIEBALDconsult2-Oct-14 14:36 
AnswerRe: Max throughput Microsoft SQL Server? Pin
Mycroft Holmes2-Oct-14 23:15
professionalMycroft Holmes2-Oct-14 23:15 
AnswerRe: Max throughput Microsoft SQL Server? Pin
Eddy Vluggen3-Oct-14 8:33
professionalEddy Vluggen3-Oct-14 8:33 
AnswerRe: Max throughput Microsoft SQL Server? Pin
jschell3-Oct-14 10:32
jschell3-Oct-14 10:32 
GeneralRe: Max throughput Microsoft SQL Server? Pin
Eddy Vluggen3-Oct-14 10:52
professionalEddy Vluggen3-Oct-14 10:52 
GeneralRe: Max throughput Microsoft SQL Server? Pin
devvvy3-Oct-14 15:38
devvvy3-Oct-14 15:38 
GeneralRe: Max throughput Microsoft SQL Server? Pin
Jörgen Andersson3-Oct-14 21:13
professionalJörgen Andersson3-Oct-14 21:13 
GeneralRe: Max throughput Microsoft SQL Server? Pin
jschell6-Oct-14 11:04
jschell6-Oct-14 11:04 
GeneralRe: Max throughput Microsoft SQL Server? Pin
devvvy7-Oct-14 13:55
devvvy7-Oct-14 13:55 
GeneralRe: Max throughput Microsoft SQL Server? Pin
jschell8-Oct-14 11:26
jschell8-Oct-14 11:26 
QuestionCan predicates in the WHERE clause affect the type of join Pin
Richard.Berry1002-Oct-14 11:16
Richard.Berry1002-Oct-14 11:16 
AnswerRe: Can predicates in the WHERE clause affect the type of join Pin
Jörgen Andersson2-Oct-14 11:34
professionalJörgen Andersson2-Oct-14 11:34 
GeneralRe: Can predicates in the WHERE clause affect the type of join Pin
PIEBALDconsult2-Oct-14 11:41
mvePIEBALDconsult2-Oct-14 11:41 
GeneralRe: Can predicates in the WHERE clause affect the type of join Pin
Jörgen Andersson2-Oct-14 11:46
professionalJörgen Andersson2-Oct-14 11:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.