Viewing 15 posts - 46 through 60 (of 104 total)
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
May 9, 2011 at 2:27 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
You should be able to open the file created from the trace using SSMS.
March 18, 2011 at 6:09 am
If you don't mind using PS see if this helps:
http://www.mssqltips.com/tip.asp?tip=1798
to narrow down the jobs that do the backups you could do something like this:
if ($instance -eq "MYINSTANCE") {$jobs=$srv.JobServer.Jobs...
March 5, 2011 at 7:33 am
Viewing 15 posts - 46 through 60 (of 104 total)