Viewing 15 posts - 46 through 60 (of 107 total)
What are your index_id and page_count values?
They might be heaps or cointains very few pages. You could look for a better script that ignores heaps and small tables.
June 6, 2011 at 1:20 am
colin.Leversuch-Roberts (6/3/2011)
June 3, 2011 at 6:27 am
SELECT name, type, type_desc FROM master.sys.server_principals
..or something
May 27, 2011 at 12:17 am
You didn't mention your SQL Server edition in one of your previous posts ...
1. In this case what will be the maximum memory used by SQL Server .?
I believe 2GB....
May 25, 2011 at 1:36 am
kr.nithin (5/13/2011)
What should be the ideal value for p.pagecount ????
As advised above you can set it to 1000.
May 13, 2011 at 1:53 am
and p.page_count >= 10
why 10? should be a lot higher value.
May 13, 2011 at 1:33 am
Did you enable lock pages in memory?
oh yeah, sorry thats ~22GB 🙂
May 11, 2011 at 2:47 am
george sibbald (4/15/2011)
read the whole thread, thats no of processors standard edition uses for index rebuilds, not how many it is licensed to use.
Oh yeah. By the way, I did...
April 15, 2011 at 5:13 am
thought it was 4 and express supports only 1.. :unsure:
April 15, 2011 at 4:05 am
Not an answer to my question but it is helpful anyways. thanks.
April 6, 2011 at 6:05 am
SQLkiwi,
What if I only can see:
Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only....
April 1, 2011 at 3:16 am
I'm not an expert but would probably start with Performance Monitor first and once you figured which counter is causing issues then focus on that and start profiler.
Also download...
March 25, 2011 at 4:34 am
Viewing 15 posts - 46 through 60 (of 107 total)