Viewing 15 posts - 20,056 through 20,070 (of 49,552 total)
What do you define as 'cache memory'? How's it measured?
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
February 27, 2012 at 3:03 pm
cphite (2/27/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
February 27, 2012 at 3:01 pm
It probably could theoretically be done in parallel (at least the select from table portion), but that would probably be a bad thing for overall system impact, so force 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
February 27, 2012 at 2:56 pm
Grant Fritchey's execution plans book (see books link in the side bar) and then Grant Fritchey's Query performance tuning distilled (purchase from your favourite book shop)
No, Grant does not...
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
February 27, 2012 at 2:53 pm
jcrawf02 (2/27/2012)
Has anyone implemented an ENDOFTIME()/BEGINNINGOFTIME() pair of functions before?
Not exactly, I wrote a bunch of period start and end functions (day, week,month, quarter, year) functions a while 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
February 27, 2012 at 2:03 pm
Create a new nonclustered index (AllocatedByID, JobStateID) INCLUDE (JobID)
Should completely prevent the deadlocks.
This is what's can be called a key-lookup deadlock. The select takes a lock on the nonclustered index...
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
February 27, 2012 at 1:52 pm
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
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
February 27, 2012 at 11:42 am
Well parameter sniffing problems require that the plan is cached and reused, and with option recompile the plan is never cached and hence can't be reused.
Note that using option recompile...
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
February 27, 2012 at 11:39 am
Track the per-process waits (sys.dm_os_waiting_tasks), the cumulative is fairly useless as a single snapshot, especially with all the ignorable waits included.
See if you can track, when that query runs slower...
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
February 27, 2012 at 10:32 am
Can you explain the problem a little more?
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
February 27, 2012 at 10:29 am
WayneS (2/27/2012)
Simon-413722 (2/26/2012)
WayneS (2/23/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
February 27, 2012 at 9:54 am
False.
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
February 27, 2012 at 8:52 am
Is the article you read taking about views (which are just saved select statements and have neither data, indexes nor statistics) or indexed views?
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
February 27, 2012 at 8:15 am
OK, but for the purposes of 'parameter sniffing', constants and parameters are much the same. SQL can tell their value at compile time meaning it can generate a plan based...
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
February 27, 2012 at 8:07 am
Backup-restore for the contents of the database, script the logins (with their SIDs) or use SSIS's transfer logins, script the jobs or use SSIS transfer jobs.
Backup-restore will transfer the same...
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
February 27, 2012 at 7:39 am
Viewing 15 posts - 20,056 through 20,070 (of 49,552 total)