Viewing 15 posts - 12,991 through 13,005 (of 49,552 total)
ivan.peter (5/27/2013)
- even an execution plan of some queries can be different (faster), if the database knows, the table fits into memory
The optimiser never considers whether 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
May 27, 2013 at 2:57 am
Mabe check google for an article on the basics of clustering?
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
May 27, 2013 at 2:55 am
Dird (5/26/2013)
It's the same thing -_ rebuild index -> avg_fragmentation_in_percent reduces along with page splits.
No.
Page splits cause fragmentation. Rebuilding an index does not reduce page splits, it reduces fragmentation...
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
May 27, 2013 at 2:52 am
Golfer22 (5/26/2013)
If you could use table variables instead of temporary tables, that could help. But it requires a large amount of memory. Upgrading memory could help.
Unlikely, since table...
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
May 27, 2013 at 2:50 am
Dird (5/26/2013)
If so would your focus be on avg_fragmentation_in_percent in order to minimise page splits?
Err....
Reducing avg_fragmentation_in_percent doesn't minimise page splits. Page splits cause fragmentation, resulting in high avg_fragmentation_in_percent.
I look at...
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
May 26, 2013 at 5:07 pm
Can you post all the printed 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
May 26, 2013 at 5:05 pm
Dird (5/26/2013)
Where are you seeing that? Which columns are the most important to look at?
avg_fragmentation_in_percent and avg page space used. You want them low and high respectively, yours are...
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
May 26, 2013 at 1:40 pm
Change the proc to print not execute the dynamic SQL and run it with exactly the parameters that result in the error every 2 weeks
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
May 26, 2013 at 1:39 pm
Yuri55 (5/26/2013)
Moreover, as all statements were executed successfully, how SP can return error-it suppose to fail on any if there is syntax error?
Because the syntax error was in the dynamic...
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
May 26, 2013 at 12:57 pm
Dird (5/26/2013)
The AutoShrink setting for the database (properties -> options -> AutoShrink). It's not what you were talking about?
Yes. Sounded like you were saying that autoshrink didn't work (disabled) in...
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
May 26, 2013 at 12:55 pm
Dird (5/26/2013)
Autoshrink is disabled in 10.5.
???
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
May 26, 2013 at 11:58 am
Dird (5/26/2013)
Oh OK, so it's just about the amount of page splits?
Not necessarily. Other things than page splits can cause fragmentation, like database/file shrink operations.
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
May 26, 2013 at 11:44 am
The syntax error is within some dynamic SQL and hence only caught when the dynamic SQL is executed. You'll need to add a PRINT statement to print the dynamic 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
May 26, 2013 at 11:36 am
Dup
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
May 26, 2013 at 11:30 am
Dird (5/26/2013)
Judging by this it would lead me to believe that only 1-2% of each page is being used?
That's not what fragmentation means. Nothing wrong with the query or...
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
May 26, 2013 at 11:27 am
Viewing 15 posts - 12,991 through 13,005 (of 49,552 total)