Viewing 15 posts - 40,291 through 40,305 (of 49,552 total)
Matt (3/18/2009)
I wondered about that but wouldn't it affect access to all tables?
No. If there's a lock on the messages table it will just affect queries on the messages 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
March 18, 2009 at 8:16 am
shnex (3/18/2009)
I have some heaps that have lots of pages(90 000) and 99% fragmentation. What should I do with them?
There's nothing you can do with them. Heaps cannot be...
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
March 18, 2009 at 8:14 am
Your first suggestion for a full tran log is to shrink it. Maybe I'm missing something, but that's completely the opposite of what's needed.
The log is full, ie, there 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
March 18, 2009 at 8:14 am
Grant Fritchey (3/18/2009)
I'm going to hell for this one, I just know it.
Nah. The dev team need their daily laugh too.
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
March 18, 2009 at 8:05 am
Double post. Never mind.
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
March 18, 2009 at 5:05 am
Tim Walker (3/18/2009)
I suppose you might say that I should check free space per page instead but I think I'd get pretty much the same result.
Not necessarily. It's very possible...
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
March 18, 2009 at 4:57 am
There's an index that should be usable for that query. Without the second filter (page index and page size), now many rows are returned?
Can you post the execution plan (saved...
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
March 18, 2009 at 4:49 am
Also note that there's a long list of limitations and restrictions on what may be in an indeed view (check Books Online) and that the first inde created on 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
March 18, 2009 at 4:36 am
Can you post 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
March 18, 2009 at 4:33 am
Tim Walker (3/18/2009)
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
March 18, 2009 at 4:26 am
Tim Walker (3/17/2009)
GilaMonster (3/17/2009)
The usual rule-of-thumb is 1000 pages to a table/index before you needs to worry about fragmentation.
This is a common view but I don't agree, I think 64-ish...
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
March 18, 2009 at 12:29 am
Please read the article I linked.
I don't want to guess as to your requirements and I would like to be able to test it before posting. Hence the request...
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
March 18, 2009 at 12:11 am
Joseph (3/17/2009)
avg_fragment_size_in_pages >= 8 AND fragmentation > 10 AND page_count >=1000
Regarding the fragment size, larger is better. The ideal is that fragment size = number of pages in index. Generally,...
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
March 18, 2009 at 12:08 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
March 17, 2009 at 3:51 pm
Of course. No point in rebuilding an index that isn't fragmented.
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
March 17, 2009 at 3:47 pm
Viewing 15 posts - 40,291 through 40,305 (of 49,552 total)