Viewing 15 posts - 25,336 through 25,350 (of 49,552 total)
Stop SQL first. They are IO stress test tools, they will push the IO subsystem as hard as it can go. You don't want SQL trying to get to its...
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 26, 2011 at 3:31 pm
I wouldn't recommend running either on a box that already has SQL running on it, unless you stop SQL for the duration.
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 26, 2011 at 3:14 pm
The counter does not distinguish between mid-index page splits (that cause data to be moved and result in fragmentation) and end-index page splits that just add a page to 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 26, 2011 at 2:56 pm
opc.three (6/26/2011)
I always use PerfMon, not sure if it's available in a DMV. If you find a DMV/F please post back 😀
Except that the perfmon counter doesn't actjually track page...
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 26, 2011 at 11:31 am
Yuri55 (6/25/2011)
I know that DB recovery happened every time we restarting service. But is it safe, can it result in data corruption or sql server takes care perfectly about everything?
Nothing...
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 26, 2011 at 11:28 am
opc.three (6/26/2011)
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 26, 2011 at 11:11 am
Make sure you have enough log space. Other than that, pretty much nothing
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 26, 2011 at 3:03 am
Use a server-side trace (profiler without the GUI)
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 26, 2011 at 3:00 am
homebrew01 (6/25/2011)
Seemed to me that you might get duplicates though because the same batch could be getting inserted at the same time.
Absolutely. You'd need some nasty isolation level to prevent...
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 26, 2011 at 2:58 am
Set the max memory low enough that there's enough free for the OS and any other apps on the server. There's no absolute rule with absolute formulas.
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 26, 2011 at 2:55 am
Sourav-657741 (6/25/2011)
Do I need rememeber anything more while setting the SQL Server memory configuration for SQL SErver 2005?
Anything more than what?
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 25, 2011 at 12:22 pm
Absolutely there's a chance. A good one.
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 25, 2011 at 3:18 am
Jim Murphy (6/24/2011)
GilaMonster (6/24/2011)
Brain overfull. Firehose-style class. So glad I have a short vacation after this.
Awesome. Some day, I'll enjoy it. You will blog about your experience there,...
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 25, 2011 at 1:46 am
Brain overfull. Firehose-style class. So glad I have a short vacation after this.
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 24, 2011 at 3:05 pm
A couple
http://sqlinthewild.co.za/index.php/2009/07/10/why-the-dmvs-are-not-a-replacement-for-sql-trace/
Weekly is no where near enough. Hourly maybe, with the exception of plans that are never cached. If you need a correct record of procedures executed, modify each 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 24, 2011 at 2:59 pm
Viewing 15 posts - 25,336 through 25,350 (of 49,552 total)