Viewing 15 posts - 9,031 through 9,045 (of 49,552 total)
Sorry, am only leaving JHB Wednesday evening. ETA for Birmingham is, I believe, about 10AM Thursday.
Besides, Aaron didn't put conditions on the free coffee...
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
May 16, 2014 at 2:18 pm
Stefan Krzywicki (5/16/2014)
GilaMonster (5/16/2014)
Grant Fritchey (5/15/2014)
Ed Wagner (5/15/2014)
SQLRNNR (5/14/2014)
Luis Cazares (5/14/2014)
I'm afraid, "he-who-shall-not-be-named" is back in the forums.I hope that I can behave well enough.
Who? Tom Marvolo Riddle?
You know,...
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
May 16, 2014 at 1:21 pm
KTurkes (5/16/2014)
I have very little knowledge about AlwaysOn, and according to our SAP on MSSQL docs it should be in a MSCS environment.
Perhaps it's worth getting someone involved 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
May 16, 2014 at 12:55 pm
rodjkidd (5/16/2014)
The SQL Bits tradition is to bag pack Wednesday evening, then drink, and eat, and drink some more!
That sounds like a suitably British way of working
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
May 16, 2014 at 12:40 pm
Grant Fritchey (5/15/2014)
Ed Wagner (5/15/2014)
SQLRNNR (5/14/2014)
Luis Cazares (5/14/2014)
I'm afraid, "he-who-shall-not-be-named" is back in the forums.I hope that I can behave well enough.
Who? Tom Marvolo Riddle?
You know, I think that...
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
May 16, 2014 at 12:35 pm
KTurkes (5/16/2014)
So compared to async mirroring sync mirroring's only disadvantage is performance impact?
Pretty much, 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
May 16, 2014 at 12:31 pm
KTurkes (5/16/2014)
GilaMonster (5/16/2014)
KTurkes (5/16/2014)
if I know correctly even one synchronized mirror fails all applications will stop until it is restored.
No, that would completely defeat the point of mirroring as a...
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
May 16, 2014 at 12:18 pm
KTurkes (5/16/2014)
if I know correctly even one synchronized mirror fails all applications will stop until it is restored.
No, that would completely defeat the point of mirroring as a High Availability...
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
May 16, 2014 at 12:09 pm
Time to give your legal dept (and maybe HR) a call, then investigate. I hope you have some auditing in place.
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
May 16, 2014 at 11:40 am
No, SQL won't by itself suddenly write data from 3 months ago. If you're seeing inserts happen, something or someone is running those inserts.
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
May 16, 2014 at 11:09 am
0 is fine for min server memory.
As for locked pages... https://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/
p.s. Don't use Task manager to check SQL Server's memory.
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
May 16, 2014 at 8:05 am
DECLARE @dt DATETIME;
SET @dt = GETDATE();
SELECT DATENAME(month,@dt), YEAR(@dt)
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
May 16, 2014 at 6:33 am
Speaking Friday and Saturday (and apparently getting free coffee while there :w00t:)
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
May 16, 2014 at 3:26 am
Eirikur Eiriksson (5/15/2014)
Question for Gail, on a 2005 platform, which solution of these two would you prefer and why?
Constraint. Less overhead, less chance of it getting altered later by...
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
May 16, 2014 at 12:48 am
Minnu (5/15/2014)
while monitoring the same in sql profiler duration is showing as '80506' milliseconds, i.e '1 min 34 seconds'
80506 ms is not 1 min 34 sec.
It's 80.5 seconds. 60 seconds...
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
May 15, 2014 at 5:01 am
Viewing 15 posts - 9,031 through 9,045 (of 49,552 total)