Viewing 15 posts - 4,486 through 4,500 (of 49,552 total)
Piotr ER (10/16/2015)
Ok, i should write "when transaction fails and rollback is completed" :). But when rollback is done - you no longer need log records.
That's still not true in...
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
October 16, 2015 at 4:56 am
Piotr ER (10/16/2015)
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
October 16, 2015 at 4:19 am
Justin Manning SA (10/16/2015)
Fair enough.. but surely a 60GB file is too small?
Assuming that the OP is talking about the page file, probably not, unless the server's crashing often...
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
October 16, 2015 at 3:35 am
mahi123 (10/16/2015)
what is the use LDF file in Simple recovery model data base.
Transaction rollbacks, database recovery after a shutdown, database integrity, minor things like that.
Is there any possibility to remove...
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
October 16, 2015 at 3:28 am
BL0B_EATER (10/16/2015)
GilaMonster (10/16/2015)
Eirikur Eiriksson (10/16/2015)
GilaMonster (10/15/2015)
Oh, and the bloody desktop booted clean to windows on the first try tonight and is behaving itself...Did you just upgrade to Windows 10?
Err, no.
win10...
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
October 16, 2015 at 3:14 am
Justin Manning SA (10/16/2015)
GilaMonster (10/16/2015)
Justin Manning SA (10/16/2015)
Isn't the rule of thumb for a Virtual Memory/Page file to be set to 1.5 x amount RAM?
It was, about 10...
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
October 16, 2015 at 3:10 am
Alan.B (10/15/2015)
-- Create a table
IF OBJECT_ID('tempdb..#X') IS NOT NULL DROP TABLE #X;
CREATE TABLE #X (x int)
-- start transaction
BEGIN TRANSACTION
INSERT #X SELECT 1
INSERT #X SELECT 2
...
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
October 16, 2015 at 3:07 am
Agnii (10/15/2015)
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
October 16, 2015 at 2:47 am
Justin Manning SA (10/16/2015)
Isn't the rule of thumb for a Virtual Memory/Page file to be set to 1.5 x amount RAM?
It was, about 10 years ago....
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
October 16, 2015 at 2:44 am
Eirikur Eiriksson (10/16/2015)
GilaMonster (10/15/2015)
Oh, and the bloody desktop booted clean to windows on the first try tonight and is behaving itself...Did you just upgrade to Windows 10?
Err, no.
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
October 16, 2015 at 2:42 am
Check the permissions of the public role.
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
October 15, 2015 at 1:27 pm
Oh, and the bloody desktop booted clean to windows on the first try tonight and is behaving itself...
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
October 15, 2015 at 1:04 pm
Eirikur Eiriksson (10/15/2015)
Gail, let us know where and when 😉
According to my blog dashboard, part 1 is scheduled for 3rd November.
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
October 15, 2015 at 12:55 pm
Virtual memory set to 60GB where? What, exactly do you mean (because virtual memory is fixed on a windows machine based on whether it's 32 or 64 bit, it's not...
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
October 15, 2015 at 12:10 pm
What exactly do you mean 'virtual memory is set to 60GB'?
And what exactly are you looking at when you say a 'virtual memory spike'?
And 3 Terabytes of RAM????
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
October 15, 2015 at 9:15 am
Viewing 15 posts - 4,486 through 4,500 (of 49,552 total)