Viewing 15 posts - 15,811 through 15,825 (of 49,552 total)
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1380263-384-1.aspx
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
November 2, 2012 at 4:52 am
No, not in general.
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
November 2, 2012 at 2:42 am
If I had to guess, and it's a complete guess since I can't see the proc, I'd say it's probably this:
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
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
November 2, 2012 at 2:30 am
john pan (10/31/2012)
I have set 3605,1204 and 1222 - deadlocking - seeing a lot of these and the scans - working on them also.
Turn 3605 off, it has nothing 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
November 2, 2012 at 2:28 am
Most likely you're getting stale statistics and the proc is sensitive to that. Just a guess since I can't see the proc.
If that is the case, you neither need 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
November 2, 2012 at 2:27 am
BriPan (11/2/2012)
try " with nolock " with select query on your tableslike select * from temptable with (nolock)
Recommending nolock with no mention of the side effects on data?
See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
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
November 2, 2012 at 2:23 am
Whichever row results from the exec plan generated for the update. This is a scenario you should be very careful to avoid when writing update statements
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
November 2, 2012 at 2:22 am
qew420 (11/1/2012)
Locked pages is when the service account has the locked pages in memory privilege. It prevents windows from paging SQL's buffer pool to disk (which would be a rather...
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
November 1, 2012 at 1:55 pm
USE TempDB;
GO
CREATE TABLE test (
id INT,
Filler CHAR(500)
);
INSERT INTO test
SELECT object_id, '' FROM sys.objects AS o;
GO
CREATE PROCEDURE TestIndex
AS
SELECT 1 FROM test WHERE id = 0;
GO
-- turn show exec plan on
EXEC...
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
November 1, 2012 at 1:24 pm
qew420 (11/1/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
November 1, 2012 at 12:07 pm
No. What's in the plan cache now is the only plan you can see unless you set up some form of tracing to capture plans.
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
November 1, 2012 at 12:05 pm
Read chapter 3, work through it. If this is a 'Must Fix Now!' crisis, tell your boss to hire a consultant.
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
November 1, 2012 at 12:03 pm
DROPCLEANBUFFERS is likely to worsen problems, not fix them, it throws the data cache out forcing SQL to read from the slower disk not memory until the cache has been...
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
November 1, 2012 at 11:31 am
Michael Valentine Jones (11/1/2012)
Or just leave it alone.
This.
For fragmentation of a non-leaf level to be of any impact, that level needs to be > ~1000 pages and for SQL 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
November 1, 2012 at 11:18 am
Please post new questions in a new thread. Thank you.
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
November 1, 2012 at 11:04 am
Viewing 15 posts - 15,811 through 15,825 (of 49,552 total)