Viewing 15 posts - 13,501 through 13,515 (of 49,552 total)
jrestuccio (4/12/2013)
[C:\Program Files\Microsoft SQL Server\MSSQL\data\tempdb.mdf] in database [tempdb] (2).
I suspect that's a good part of the problem. If I had to guess, lots of TempDB usage and TempDB still...
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
April 12, 2013 at 9:44 am
johnmcp (4/12/2013)
Oops :pinch:That would be the transactions table.
🙂 I'll take a look a bit later if I find the time.
Now that I think of it, I didn't specify fullscan....
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
April 12, 2013 at 8:52 am
curious_sqldba (4/10/2013)
25000 inner loops is the issue.
Why?
I could easily force it to use hash and make it perform better.
Have you tested that and seen that forcing a hash...
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
April 12, 2013 at 8:51 am
Lynn Pettis (4/8/2013)
jrestuccio (4/8/2013)
Here you go, I tried to include all relevant information.Again thanks for helping!
-Josh
2) Actual execution plan as a .sqlplan file, not XML plans you included in 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
April 12, 2013 at 8:47 am
jrestuccio (4/12/2013)
Also, the "save execution plan" is greyed out in SSMS express, so what's the best way to get you the execution plan?
See the article in Craig's sig. Describes how...
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
April 12, 2013 at 8:46 am
I might be able to explain, if I knew which table the '4th table' was. 😉
Is that the actual plan from before the stats update or after?
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
April 12, 2013 at 8:37 am
Lynn Pettis (4/12/2013)
GilaMonster (4/12/2013)
There's absolutely no need to use temp tables in that, doing so just adds complexity and reduces the performance.
True, Gail, but apparently it is required that 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
April 12, 2013 at 8:28 am
There's absolutely no need to use temp tables in that, doing so just adds complexity and reduces the performance.
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
April 12, 2013 at 8:02 am
There is, but to be honest you shouldn't be using nolock everywhere. It's not a go-faster switch, it is not a performance tuning technique, it is not necessary to make...
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
April 12, 2013 at 6:31 am
Or open the error log in notepad.
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
April 12, 2013 at 5:37 am
Network service is OK for SQL Agent, providing it doesn't need more permissions than network servce grants.
Double check, is it absolutely, certainly, definitely not running as your account? Double check...
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
April 12, 2013 at 4:29 am
Try updating stats with full scan and then the query with the getdates again.
To diagnose the problem, I really need to see the actual plan of that 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
April 12, 2013 at 2:41 am
What is the SQL Server agent service account?
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
April 12, 2013 at 2:28 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
April 11, 2013 at 3:51 pm
sqlfriends (4/11/2013)
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
April 11, 2013 at 12:48 pm
Viewing 15 posts - 13,501 through 13,515 (of 49,552 total)