- 论坛徽章:
- 0
|
新手求教,请帮忙看看怎么解决
0:00000:00002:2016/05/27 17:46:43.90 server There are not enough 'user connections' available to start a new process. Retry when there are fewer active users, or ask your System Administrator to reconfigure SQL Server with more user connections.
00:00000:00024:2016/05/27 18:51:29.62 server Named cache default data cache, id 0 configured too small for current demands. Transaction progress may cease or response time may increase.
00:00000:00013:2016/05/27 18:51:30.21 server Named cache default data cache, id 0 configured too small for current demands. Transaction progress may cease or response time may increase.
11> sp_configure "Memory Use"
12> go
Group: Memory Use
Parameter Name Default Memory Used Config Value
Run Value
------------------------------ ----------- ----------- ------------
-----------
additional network memory 0 0 0
0
allow resource limits 0 0 0
0
audit queue size 100 42 100
100
default network packet size 512 #1020 512
512
disk i/o structures 256 21 256
256
enable rep agent threads 0 0 0
0
event buffers per engine 100 #10 100
100
executable codesize + overhead 0 7888 0
7888
max cis remote servers 25 0 25
25
max number network listeners 5 399 5
5
max online engines 1 151 1
1
max roles enabled per user 20 #4 20
20
memory per worker process 1024 0 1024
1024
number of alarms 40 2 40
40
number of aux scan descriptors 200 #99 200
200
number of devices 10 #11 30
30
number of languages in cache 3 4 3
3
number of large i/o buffers 6 97 6
6
number of locks 5000 528 5000
5000
number of mailboxes 30 1 30
30
number of messages 64 2 64
64
number of open databases 12 433 12
12
number of open indexes 500 208 500
500
number of open objects 500 237 500
500
number of remote connections 20 805 500
500
number of remote logins 20 214 200
200
number of remote sites 10 797 10
10
number of user connections 25 1986 25
25
number of worker processes 0 0 0
0
partition groups 1024 21 1024
1024
permission cache entries 15 #26 15
15
procedure cache percent 20 2082 20
20
remote server pre-read packets 3 #786 3
3
stack guard size 4096 #200 4096
4096
stack size 34816 #1701 34816
34816
total data cache size 0 8040 0
8040
total memory 12000 24000 12000
12000
1> sp_cacheconfig
2> go
Cache Name Status Type Config Value Run Value
------------------------------ --------- -------- ------------ ------------
default data cache Active Default 0.00 Mb 7.44 Mb
------------ ------------
Total 0.00 Mb 7.44 Mb
==========================================================================
Cache: default data cache, Status: Active, Type: Default
Config Size: 0.00 Mb, Run Size: 7.44 Mb
Config Replacement: strict LRU, Run Replacement: strict LRU
IO Size Wash Size Config Size Run Size APF Percent
-------- --------- ------------ ------------ -----------
2 Kb 1522 Kb 0.00 Mb 7.44 Mb 10
(return status = 0)
1> select @@pagesize
2> go
-----------
2048
(1 row affected)
1>
1> sp_configure 'object'
2> go
Msg 17411, Level 16, State 1:
Procedure 'sp_configure', Line 159:
Configuration option is not unique.
Parameter Name Default Memory Used Config Value
Run Value
------------------------------ ----------- ----------- ------------
-----------
number of open objects 500 237 500
500
open object spinlock ratio 100 0 100
100
(1 row affected)
(return status = 1)
1>
1> select @@max_connections
2> go
-----------
9990
|
|