Viewing 15 posts - 631 through 645 (of 854 total)
Thank you, but why char instead of varchar fields, why?
May 6, 2009 at 10:38 am
I was told to check everything and I can't get any info from others only on my own.
When you say
char instead of varchar fields, why? How can I check...
May 6, 2009 at 10:19 am
Thank you so much, you explained a lot to me.
Question:
You said that I have signs of memory pressure. What would you say, exacly, what sign, my buffer is 92%(taht's...
May 6, 2009 at 10:04 am
I want to monitor if I have enough space on the sql server itself. Thank you
May 6, 2009 at 8:33 am
Thank you for your help, this microsoft guy came and looked at our enviroment and did not recommend it. My company wants to stick with his recomendations. He said that...
May 5, 2009 at 1:35 pm
Where did you see this recommendation? My network admin spoke to Microsoft and
we were looking at the SQL server’s boot.ini file to insure that the /3GB switch WAS NOT present....
May 5, 2009 at 9:29 am
Microsoft strongly recommends that we NEVER set this switch due to SQL 2000 2GB memory limit. How to see how much memory my server is using?What can I clean in...
May 5, 2009 at 8:26 am
Thank you so much for your help, how can I get to boot.ini file ?and get access to 3 GB How can I find out if it works only in...
May 4, 2009 at 8:06 pm
Also, should I change it back to sp_configure to 0. or I can leave it?
May 4, 2009 at 2:38 pm
Ok, I re ran sP_reconfigure
affinity mask-2147483648214748364700
allow updates0100
awe enabled0111
c2 audit mode0100
cost threshold for parallelism03276755
Cross DB Ownership Chaining0100
cursor threshold-12147483647-1-1
default full-text language0214748364710331033
default language0999900
fill factor (%)010000
index create memory (KB)704214748364700
lightweight pooling0100
locks5000214748364700
max degree of parallelism03200
max server...
May 4, 2009 at 2:32 pm
I don't see that option in advance settings to change sp_configure, do I need to add more space. Thank you
May 4, 2009 at 2:20 pm
How to get to Use Windows Performance Monitor counters?
Thank you
May 4, 2009 at 2:15 pm
You'll need to set your advanced options for sp_configure to ON for your max server memory values to display. If I sat on is this going damage anything, any performance...
May 4, 2009 at 2:06 pm
How much memory is in your server?
8163 (MB)
What is your max server memory set at (sp_configure)?6115 in MB
Name ...
May 4, 2009 at 1:50 pm
Viewing 15 posts - 631 through 645 (of 854 total)