Viewing 15 posts - 16,231 through 16,245 (of 49,552 total)
Jeff Moden (10/8/2012)
Reads from the physical disk are always read into the "Buffer Pool". It's the reads from that "Buffer Pool" that SQL Profiler counts.
Easiest way to think about...
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 8, 2012 at 4:03 pm
Traceflag 1204 just produces the old-style deadlock graph. If you have 1222 on or are pulling deadlock graphs from the extended events sessions, you probably don't want it turned on...
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 8, 2012 at 2:15 pm
But no data loss possible if the mirroring was synchronised at point of failure, and no possibility of data loss when failing back?
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 8, 2012 at 10:06 am
I can understand data loss in the case where the network connection drops first and the principal server fails at some point later while still disconnected (but data loss could...
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 8, 2012 at 10:04 am
WayneS (10/6/2012)
Hi Phil,I'm curious as to the source of the password list that you utilize. Is it something that you can share a link with?
Personally I use crossword word-list sites.
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 8, 2012 at 9:56 am
In general... write queries that do what you want and write them in the logical way to achieve it. If performance proves to be unacceptable, then start considering alternatives. Don't...
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 8, 2012 at 9:45 am
Perry Whittle (10/8/2012)
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 8, 2012 at 9:42 am
If you got that conclusion from my blog post I clearly need to rewrite it.
Write your queries logically, if you mean OR, use OR. If that performs unacceptably, then consider...
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 8, 2012 at 9:22 am
2. Execute the following on serverB to make the database service available:
ALTER DATABASE <database name> SET PARTNER OFF
RESTORE DATABASE <database name> WITH RECOVERY
3. Once Server A becomes available, you need...
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 8, 2012 at 9:19 am
The only people who know the future of SQL Server are the dev team (and maybe not even them). SSIS, SSRS and SSAS part of SQL 2012. If you're 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
October 8, 2012 at 8:53 am
a.SQL.com (10/8/2012)
NehwalSaina12 (10/8/2012)
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 8, 2012 at 8:50 am
DBA_Learner (10/8/2012)
Thanks Gila. But my question is how to resume the Principal server and make the Mirror server database into Recovering state
By running the exact same command a second...
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 8, 2012 at 8:49 am
Nope, someone would have had to run the statement to put the DB into single user mode.
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 8, 2012 at 8:11 am
Don't use the profiler GUI on a busy production server (that's in any edition of SQL). It's got a high overhead. Use server-side traces or, in SQL 2008 and 2012,...
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 8, 2012 at 8:08 am
Not being nasty here, but are you using google before posting your questions?
http://sqlserverpedia.com/wiki/Memory_-_Lazy_Writer_and_Checkpoint (1st hit in google)
http://sqlinthewild.co.za/index.php/2009/06/26/the-lazy-writer-and-the-checkpoint/ (3rd hit in google)
http://blogs.msdn.com/b/psssql/archive/2010/03/24/how-it-works-bob-dorr-s-sql-server-i-o-presentation.aspx (10th hit in google)
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 8, 2012 at 8:06 am
Viewing 15 posts - 16,231 through 16,245 (of 49,552 total)