I have checked that. but now my sql server is still only using 2.8Gb our of 8GB.
the details are:
c2 audit mode0100
cost threshold for...
Yes, all rebooted, but still the memory usage is lower than 3GB although the server load is high
The database is pretty big, about 500,000 to 1million transactions/day. It got some performance issue last week but the memory usage stays same,...
I have changed it to 7000Mb.
Still it doesn't take the memory sql server needs to use.
Yes, I have set the maximum to 7585MB.
and the minimum is 1200MB.
I can change it to 7000Mb ( obviously one GB is taken by OS)
but I don't think...
I have checked all the posts you recommend and actually I have read them all before I post my issue.
The thing is ;
- the sql server 2000...
Can anyone help me on this memory issue?
memory configuration issue:
one server box(win2003 EE sp1) with 8GB ram, win 2003 sp1 and sql sever 2000...
the one I use is sql server 2000 sp3. Enterprise version.
Windows 2003 sp1 enterprise version
SQL database server memory configuration issue:
one server box with 8GB ram, win 2003 sp1 and sql sever 2000 sp 3 installed.
I have done:
thanks for you advice for I have same question as well.
Based on your way, if I set up a 4-node cluster, how many of them is active?
I have similar problem with one of our production servers as well.
how to check the processes? via sql trace? via profiler? via sp_who2?
throught the windows task manager, can't see any thing else use cpu...
thanks for your information.
sp3 was appatched three years ago, sp4 is on hold.
this morning I got alerts again ( cpu 100%), after I restart sql...
Just some more extra information:
When I noticed the 100% cpu usage, I restarted the sqlagent service and the cpu used by sql agent will be down to...
I just encountered one problem with our db server, which has been with 100% cpu usage all day for a few days. Before It was busy with 80% cpu...
I just experienced a strange problem with our cluster, Node A was active node and running well before I fail over all service to node B....
besides, based on my understanding, it's quite difficult to change the sql collation after it has been set up during installation....
want to ask which collation I need to use when I create a database - windows collation or sql server collation?
regardingless the legacy...
Separate names with a comma.