Viewing 15 posts - 2,941 through 2,955 (of 49,552 total)
coolchaitu (6/16/2016)
max server memory just controls the buffer pool, not CLR, full text,multiple other processes that run outside of the Buffer Pool memory
Those are small amounts of memory usually, few...
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
June 16, 2016 at 10:47 am
k2000.rajesh (6/16/2016)
DB is full recovery mode , we dont have any log backups after full back up was taken at 7:00 AM
What times do you have log backups from?
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
June 16, 2016 at 6:27 am
VastSQL (6/16/2016)
k2000.rajesh (6/16/2016)
The full back up was taken at 7:00 AM
Users did the work till 4:30 PM
Records were deleted at 4:45 PM
I...
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
June 16, 2016 at 6:26 am
The application will request memory, windows will ask SQL to reduce memory usage, SQL will reduce.
Better would be for you to go and set max server memory slightly lower to...
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
June 16, 2016 at 4:56 am
ztoddw (6/15/2016)
I'm reading about Tail-Log Backups now-- looks like that's probably what would help out here...
Nope, those are for when you're moving a database without data loss or a database...
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
June 16, 2016 at 2:05 am
ztoddw (6/15/2016)
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
June 15, 2016 at 3:26 pm
ztoddw (6/15/2016)
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
June 15, 2016 at 12:55 pm
You can call it that, yes.
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
June 14, 2016 at 3:46 pm
The what edition? Where does 'breadth' come from and in what context? It's not an edition of SQL
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
June 14, 2016 at 3:42 pm
No page has that ID (resource DB would be 32767:1:XX). Could be referring to an entry in the metadata, but not sure.
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
June 14, 2016 at 3:41 pm
Yes, that will insert successfully, and that's the correct, expected behaviour.
You've defined the primary key on two columns, therefore the combination of the two has to be unique, not the...
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
June 14, 2016 at 3:38 pm
And example of duplicates that succeed? Because
INSERT INTO C (V, CT)
VALUES ('1234567890', 'aa')
GO
INSERT INTO C (V, CT)
VALUES ('1234567890', 'aa')
GO
Msg 2627, Level 14, State 1, Line 5
Violation of PRIMARY KEY constraint...
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
June 14, 2016 at 2:59 pm
It'll break your recovery process and leave you unable to restore to point in time until another full backup is taken. Won't break mirroring, but that may be a small...
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
June 14, 2016 at 12:47 am
Bear in mind that the majority of SQL's memory won't belong to any session, it'll be the data cache and the plan cache
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
June 13, 2016 at 10:22 am
Y.B. (6/13/2016)
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
June 13, 2016 at 8:48 am
Viewing 15 posts - 2,941 through 2,955 (of 49,552 total)