Viewing 15 posts - 406 through 420 (of 854 total)
I have around 190 million records.What would be the quickest way to delete them?
January 18, 2010 at 6:47 am
my AWE is not check, in my case should I check it to true?
January 13, 2010 at 9:58 am
Thank you, we are still having problems and I need your help please
with this instanse
counter_nameinstance_namecntr_value
Target Server Memory (KB) 1024000
Total...
January 13, 2010 at 9:43 am
Buffer CountsBuffers
Committed102400
Target102400
Hashed43268
Stolen Potential53512
External Reservation0
Min Free32
Visible102400
Available Paging File304972
January 12, 2010 at 12:10 pm
counter_nameinstance_namecntr_value
Target Server Memory (KB) ...
January 12, 2010 at 11:22 am
How to check if I have enough memory on a instanse
January 8, 2010 at 2:43 pm
counter_nameinstance_namecntr_value
Target Server Memory (KB) 819200
Total Server Memory (KB) ...
January 8, 2010 at 2:40 pm
Thank you everyone for your help,
Question what should I look for and how that I would have enough memory on my instanse.
January 8, 2010 at 2:30 pm
You can shut down the services for the two unneeded instances in the Control Panel | Servers, and set their startup to "manual".
I am not sure if I shut down...
January 8, 2010 at 1:26 pm
We installed 1 more processor,but it is not showing that we have 2 now,what do we need to do Thank you
January 8, 2010 at 1:08 pm
Do I need to re boot after I changed max memory settings?
I don't expect production to run queries developed in dev with parallelism. Can main instanse be disable and all...
January 8, 2010 at 11:43 am
Oh, I didn't change max memory for my maine instanse, do I need it? I only changed max memory for all 9 instansases
January 8, 2010 at 11:18 am
I stoped 4 instances that we are not using and changex max settings and now I have these:
counter_nameinstance_namecntr_value
Target Server Memory (KB) ...
January 8, 2010 at 11:09 am
IndexNameInternal_ValueCharacter_Value
1ProductNameNULLMicrosoft SQL Server
2ProductVersion5898249.00.3068.00
3Language1033English (United States)
4PlatformNULLNT INTEL X86
5CommentsNULLNT INTEL X86
6CompanyNameNULLMicrosoft Corporation
7FileDescriptionNULLSQL Server Windows NT
8FileVersionNULL2005.090.3068.00
9InternalNameNULLSQLSERVR
10LegalCopyrightNULL© Microsoft Corp. All rights reserved.
11LegalTrademarksNULLMicrosoft® is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of...
January 8, 2010 at 9:57 am
Viewing 15 posts - 406 through 420 (of 854 total)