Viewing 15 posts - 31,591 through 31,605 (of 49,552 total)
Kwisatz78 (7/28/2010)
Hi Gail 🙂In response to your questions, the queries I am using are below
The second is not going to work properly. The order by on the date column will...
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
July 28, 2010 at 9:34 am
Kwisatz78 (7/28/2010)
I have used SQl and DBCC PAGE to try and figure out what data is missing. What we have found is...
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
July 28, 2010 at 8:05 am
There's no way to tell that for certain. You can guess, based on the predicates in the query and the joins which ones will likely be used.
Or, if you have...
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
July 28, 2010 at 6:34 am
leebuckman (7/28/2010)
Interestingly, if i specify the insert for just one customer ie 8458923, it is correct every time. (so the order...
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
July 28, 2010 at 4:51 am
harit79 (7/28/2010)
Query takes only 4-5 second but we have a requirment that logical read should be <=5000.
Why? Where's the logic in that?
If the query is not a performance bottleneck, 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
July 28, 2010 at 4:16 am
leebuckman (7/28/2010)
But the question remained, why did it work before and does not now, hence my post on here !
Basically your colleague was depending on undocumented and incorrect behaviour 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
July 28, 2010 at 4:10 am
Why the requirement of logical reads under 5000? That's an odd requirement for tuning. Usually one tries to get it as fast as possible, or the reads as low as...
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
July 28, 2010 at 3:40 am
leebuckman (7/28/2010)
Thanks for the replies but i am still at a loss here. Let me explain further and simplify the query and exactly what i am trying to do. I...
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
July 28, 2010 at 3:34 am
Also note that MAXDOP sets the maximum allowed degree of parallelism. It doesn't set the exact parallelism used.
Just because there's a MAXDOP hint on a query doesn't mean SQL...
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
July 28, 2010 at 2:02 am
sivaprasad (7/27/2010)
MAXDOP - Maximum Degree of Parallism ....
When you quote from Books Online or MSDN, you should site your source.
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
July 28, 2010 at 2:01 am
sivaprasad (7/28/2010)
Say i have 8 processor and affinity mask is set to 4.What will happen if i gave max degree of parallelism as 6??Is it possible???
Yes, you can have...
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
July 28, 2010 at 1:58 am
mdfaraz (7/27/2010)
1. Is there a limit to the number of record inserts SQL server 2008 can handle.
Only limited by your hardware, but it's not a few thousand. I've...
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
July 27, 2010 at 11:44 pm
Please post your question 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
July 27, 2010 at 11:34 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic959826-148-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
July 27, 2010 at 11:34 pm
That looks like traceflag 1204's output. Limited and hard to read.
Switch traceflag 1204 off, switch 1222 on. The deadlock graph will have two sections, where it shows the processes involved...
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
July 27, 2010 at 3:33 pm
Viewing 15 posts - 31,591 through 31,605 (of 49,552 total)