Viewing 15 posts - 32,146 through 32,160 (of 49,552 total)
Jeff Moden (6/28/2010)
...and the data on each page is also in physical order.
Not necessarily. Rows on a page don't have to be in any specific order, SQL puts them where...
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 28, 2010 at 11:38 pm
I would strongly recommend that you do not go that route, it'll lead to horrendously complex triggers, usually needing dynamic SQL, often having difficulty with the inserted and deleted tables...
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 28, 2010 at 11:37 pm
sam-1083699 (6/28/2010)
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 28, 2010 at 2:58 pm
nelsonj-902869 (6/23/2010)
Do NOT try to 'repair' the table/database without researching what the repair could possibly do to your data.
stricknyn (6/28/2010)
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 28, 2010 at 2:56 pm
Doesn't sound like corruption, sounds like blocking.
If you query the table then, in another query window query sys.dm_exec_requests. Find the row that refers to the query that you're running against...
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 28, 2010 at 2:55 pm
sam-1083699 (6/28/2010)
How come the same code works differently when i ran on both servers?
Many possible reasons. Different hardware, different load, different version of SQL, that's just 3 off 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 28, 2010 at 2:25 pm
Check what the blocking query is. If you ckeck sys.dm_exec_requests, you'll see a columns called blocking_session_id. That's the session_id of the session that's holding the locks that prevent the query...
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 28, 2010 at 2:12 pm
Remove pieces (joins typically, or complex Where clause predicates) of the query and see what the smallest, simplest portion that you can find that still shows the performance problem.
Can 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
June 28, 2010 at 2:04 pm
David-155102 (6/28/2010)
I also found that the client application that accesses the database has a load of in-line queries which I suspect is causing the problem.
Yup, they'll require direct access 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 28, 2010 at 2:01 pm
Yes
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 28, 2010 at 2:00 pm
bhjodokast (6/28/2010)
I have images disabled on my browser, maybe that is why it's not showing properly.
That's precisely why that's happening. The 'strings' that you see are the ALT Text...
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 28, 2010 at 10:07 am
You can use sum because, if you check the code that Gianluca posted, you're summing 1 or 0, 1 if that row is to be counted, 0 if it's 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
June 28, 2010 at 10:04 am
Dave Ballantyne (6/28/2010)
Sure about that Gail ?Difference in 2005 / 2008 Perhaps ?
This profiler trace screen shot is 2005.
Doesnt Look like the update statistics has invalidated the plan.
Yes, absolutely sure...
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 28, 2010 at 9:55 am
Sam, first thing I'll suggest is that you remove all of your join hints from the query, then see how it performs on the two servers.
Also, fix the EXISTS, there's...
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 28, 2010 at 9:29 am
Dave Ballantyne (6/28/2010)
The table STOREROOM has an estimated row count of 7 but actual of 250,000+.
That's a correct estimate.
7 rows (estimated) * 36876 (number of executions) = 258132 (actual...
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 28, 2010 at 9:24 am
Viewing 15 posts - 32,146 through 32,160 (of 49,552 total)