Chapter 5 Installation and Setting of NEC Storage ReplicationControl SQL Option
44
5
5
5
.
.
.
6
6
6
.
.
.
1
1
1
C
C
C
h
h
h
a
a
a
n
n
n
g
g
g
e
e
e
o
o
o
f
f
f
W
W
W
o
o
o
r
r
r
k
k
k
e
e
e
r
r
r
T
T
T
h
h
h
r
r
r
e
e
e
a
a
a
d
d
d
M
M
M
a
a
a
x
x
x
i
i
i
m
m
m
u
u
u
m
m
m
N
N
N
u
u
u
m
m
m
b
b
b
e
e
e
r
r
r
When the snapshot backup and snapshot restoration have been executed, worker threads are consumed
in the Microsoft SQL Server 2000.
Especially when snapshot backups are simultaneously performed on multiple databases, the number of
worker threads consumed increases in proportion to the number of databases. When the number of
available worker threads has been used up and new worker threads cannot be created, the NEC Storage
ReplicationControl SQL Option results in an abnormal end, displaying the following message:
iSM13689: Failed to snapshot execution. code=3627
Therefore, when snapshot backups are simultaneously performed on many databases, beforehand it is
necessary to make available the necessary maximum number of worker threads.
Indication of the maximum number of the worker threads
= Default 255 + (The number of databases on which snapshot backups are simultaneously
performed
×
2)
Although the default number of worker threads is 255, those worker threads are also consumed by other
processes that use the Microsoft SQL Server 2000. Therefore, when processes other than the NEC
Storage ReplicationControl SQL Option also use the Microsoft SQL Server 2000, it is necessary to take
into consideration the number of worker threads consumed by those processes when setting the
maximum number of worker threads.
Change the worker thread maximum number according to the following procedure:
(1) From the Microsoft SQL Server’s menu, start Enterprise Manager.
(2) Select the target instance and display the properties.
(3) Select the “Processor” tag and change the worker thread maximum number controlled by the
processor.
(4) Resume the instance service.
Summary of Contents for Storage ReplicationControl SQL Option
Page 1: ...NEC Storage ReplicationControl SQL Option User s Manual ...
Page 54: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 48 ...
Page 61: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 55 ...
Page 70: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 64 ...
Page 76: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 70 ...
Page 83: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 77 ...
Page 104: ...87 U uninstallation 42 update 42 W worker thread 44 ...
