SQL Server
Introduction
SQL Server is a competitor in M i C R O S O f T to Relational Database Management System (R D B M s) market, which competes with its competition includes O R A C L E and I N f O R m I x. SQL Server runs on the operating system of the Windows NT / 2000 server and many other M i C R O S O F T. It provides a support for TR a N s a c t - s q L, TR a N S Q, is a branch of industrial standard SQL (Structure Language, Structured Query language) interacting with R D b M s application. SQL Server has many other powerful functions such as distributed transaction (Distributed TR a N S A C T I O N S), Database Replication. SQL Server got support for the A D O and R D O database access technology of M i C R O S O F T, while supporting Open Database Connectivity (O D B C).
SQL Server features
In addition to the characteristics of its own, SQL Server also allows other several powerful M ICrosoft products and technologies:. Distributed transaction processing using distributed transaction coordinations (DTC) (cross two Platform). Database replication. WE B server connection. Record NT events. A variety of network protocols. Support Open Database Connectivity (ODBC). Using the M ICrosoft Transaction Server (Microsoft Transaction Server, MTS) Transaction processing (using different RDBMS)
ODBC
O D B C is an industrial standard that allows any developers to develop applications that are independent of the database internal structure. S Q Ls E R V E r fully supports O D B C, allowing it to work with many of many different suppliers' R D B M s applications and components.
ADO and RDO
A c T i V e x data object (ActiveX Data Objects, A D O) and remote data objects (R D O) are two main service technologies currently used by M i C R O S O F T. Because it supports O D B C, SQL Server is fully accessible to A D O and R D O components and applications.
SQL Server provides services
SQL Server includes a special service that is very special for the system, which is usually accessed through the Enterprise Manager (Enterprise Manager, as shown in Figure 1 5 - 1). SQL Server's Enterprise Manager provides access to S Q LE X E C U T I v E, S Q L - D M O and SQL Replication Services. The Enterprise Manager itself is the M i C R O S O F T Management Console (M m c) application, which can be merged with other M M c program (Component Services, Component Services) or added to other M m c programs. 1. SQL EXECUTIVESQL Executive is a service application that manages connection, access, and SQL Server events. It must run for other available functions of S Q LS E R V E R. 2. SQL-DMOSQL-DMO (SQL Distributed Management Objects) is SQL Server with an enterprise-class feature (actually a programming interface) that allows remote components to use a central SQL Server database. S Q L - D M o requires several additional devices to work on hosts and clients. 3. SQL ReplicationsQL Server can copy its database for backup. SQL Replication is also controlled by SQL EXECUTIVE. Copy is a complex process involving a scheduled task engine, a task list, synchronization, and subscription.
Configure the correct list of correctly known network libraries for SQL Server
SQL Server E x E C U T I v e requires trusted connection, in fact, this usually means that a famous pipe should be used (although N e t b e U I lacks routing ability). There is a problem when SQL Server's parallel equipment is placed on the same machine. The following describes how to change the registry to solve this problem: 1) Open the Start menu and select "Run". Click the "Browse" button to start navigation until the root directory of Wi N D O W S2 0 0 0 (usually W I N N T) is found. Go to the S Y S t e m directory and find R E G E D T 3 2. E X E, select it to the dialog and click the "OK" button. The Registry Editor is launched, and all configuration units are displayed in different laminate windows, respectively. 2) Select "Window" menu item H k e y _ L O c a l _ m a c h i n e, its sub-window display. Maximize this window for use. 3) Position the tree control using the left window to the S O F T Ware / Microsoft / MSSQLServer / SQL Executive child. Click this subkey to select it, display its value in the right window. 4) Position the entry to the value S e r v E R H O S T. Use the string editor to change the value of S E R v E R H O S T as a famous pipe to use.
Solve SQL Server is a problem with the Windows 9x workstation connection
SQL Server uses a famous pipe to be very touched, which will slow down due to the problem of a registry set on the Windows 9x workstation. The following describes how to change the registry to solve this problem: 1) Run the R e g e d i t on the Windows 9x machine. E X E. 2) Select "Window" menu item H k e y _ L O c a l _ m a c h i n e, its sub-window display. Maximize this window for use. 3) Use the tree control of the left window to position to S Y S-t E M / C U R R E N T C O N T R O L S E T / S E R V I C E S / V X D / V N E T 's UP Up. Click this subkey to select it, display its value in the right window. 4) Create a new value named D i R E C T H O S T, whose type is R e g _ S Z. Set 0 D i R E C T H O S T, which can close the Direct Hosting of the workstation, and resolve the slow connection problem. Increase the number of DB-library connections available for SQL Server
SQL Server provides fixed number D B - L I B R A R Y concurrent connections for SQL EXECUTIVE. If the system supports more concurrent connections, the system administrator can add this setting by modifying the registry: 1) Open the Start menu and select "Run". Click the "Browse" button to start navigation until the root directory of Wi N D O W S2 0 0 0 (usually W I N N T) is found. Go to the S Y S t e m directory and find R E G E D T 3 2. E X E, select it to the dialog and click the "OK" button. The Registry Editor is launched, and all configuration units are displayed in different laminate windows, respectively. 2) Select "Window" menu item H k e y _ L O c a l _ m a c h i n e, its sub-window display. Maximize this window for use. 3) Position the tree control using the left window to the S O F T Ware / Microsoft / MSSQLServer / SQL Executive child. Click this subkey to select it, display its value in the right window. 4) Add a new value named M a X D B P R O C E S E S, type R E G _ D W O R D. Set the value of M a X D B P R O C E S S E S as the desired D B - L I B R A R Y and concurrent connections. Because of the system load, the actual number of available numbers is 3 compared to the value set. This technology only works on the SQL Server 6.5 or higher. It is suggested that the default value of M a X D B P R O C E S E S is 6 1.
SQL Server startup failure caused by slow RPC initialization
When a server's RPC (remote procedure call) service is initialized, SQL Server (configured to use multiple protocols) When starting before the RPC service is initialized, it will cause SQL Server failure, because It relies on RPC services. This is a less occurrence but annoying mistake. Fortunately, modify the registry can prevent this problem. 1) Open the Start menu and select "Run". Click the "Browse" button to start navigation until the root directory of Windows 2000 is found (usually W I N n). Go to the S Y S t e m directory and find R E G E D T 3 2. E X E, select it to the dialog and click the "OK" button. The Registry Editor is launched, and all configuration units are displayed in different laminate windows, respectively. 2) Select "Window" menu item H k e y _ L O c a l _ m a c h i n e, its sub-window display. Maximize this window for use. 3) Use the tree control of the left window to locate the S Y S-t E M / C U R R E N T C O N T R O L S e T / S E RE E S / M s S ql S e R. Click this subkey to select it, display its value in the right window. 4) Creating a new value named D e p e n D O N s e r v i c e, type R E g_ m u lt i _ s z. Enter string R p c s s as its setting. Restart the server, the problem will be corrected. Solve the login failure of the SQL Server Executive service
SQL Server sometimes does not start properly because E x e c u t i v e service cannot be logged in. One of the main reasons is that local system account and administrator group cannot fully control two registry entries. To access these two registry, you can set the registry following the steps below: 1) Open the Start menu and select "Run". Click the "Browse" button to start navigation until the root directory of Windows 2000 is found (usually W I N n). Go to the S Y S t e m directory and find R E G E D T 3 2. E X E, select it to the dialog and click the "OK" button. The Registry Editor is launched, and all configuration units are displayed in different laminate windows, respectively. 2) Select "Window" menu item H k e y _ L O c a l _ m a c h i n e, its sub-window display. Maximize this window for use. 3) Tree control using the left window is positioned to S Y S Y T E M / C U R R E N T C O N T R O L SE / S q L e C U.. Click this subkey to select it, display its value in the right window. 4) Make sure that Local System Account and Administrator Group have complete control of this and their subtries. 5) Repeat step 3, step 4, for S Y S Y, S-t E M / C E R R, S Y, E R V, E R / M S Q1.
Solve the failure of all tasks of SQL Server
SQL Server has several levels of tasks fail, including partial tasks failing, and all tasks fail. In the latter case, a registry entry and conflict with a famous pipe when a problem occurs. To resolve this conflict, you can modify the registry in accordance with the following steps: 1) Open the Start menu and select "Run". Click the "Browse" button to start navigation until the root directory of Wi N D O W S2 0 0 0 (usually W I N N T) is found. Go to the S Y S t e m directory and find R E G E D T 3 2. E X E, select it to the dialog and click the "OK" button. The Registry Editor is launched, and all configuration units are displayed in different laminate windows, respectively. 2) Select "Window" menu item H k e y _ L O c a l _ m a c h i n e, its sub-window display. Maximize this window for use. 3) Position the tree control using the left window to the S O F T Ware / Microsoft / MSSQLServer / SQL Executive child. Click this subkey to select it, display its value in the right window. 4) Position the entry to the value S e r v E R H O S T. Use the string editor to change its value so that it does not include the server name (including the famous pipes you want to use). Configure SQL Server EXECUTIVE to write a detailed log file
Sometimes, debugging SQL Executive is a must. In this case, modify the registry with the following steps to let SQL EXECUTIVE write a detailed log file: 1) Open the Start menu and select "Run". Click the "Browse" button to start navigation until the root directory of Wi N D O W S2 0 0 0 (usually W I N N T) is found. Go to the S Y S t e m directory and find R E G E D T 3 2. E X E, select it to the dialog and click the "OK" button. The Registry Editor is launched, and all configuration units are displayed in different laminate windows, respectively. 2) Select "Window" menu item H k e y _ L O c a l _ m a c h i n e, its sub-window display. Maximize this window for use. 3) Position the tree control using the left window to the S O F T Ware / Microsoft / MSSQLServer / SQL Executive child. Click this subkey to select it, display its value in the right window. 4) Add a new value called VE R B O S E F I L E and the data type of R E G_ S Z. Set the full path and file name of the log file that VE R B O S E F I L E to want to use. Stop and start SQL Executive, it will write a detailed log file in this location until this entry is deleted.
Resolve the failure of SQL Server Executive version detection
SQL Server e x e c u T i V e Sometimes a problem occurs because it cannot be started because the current SQL Server version number cannot be detected. This is a problem caused by registry access permissions, which can be resolved by giving local systema ccount and administrator group to the Current Ve Rsion registry key, as follows: 1) Open the "Start" menu and select "Run" . Click the "Browse" button to start navigation until the root directory of Wi N D O W S2 0 0 0 (usually W I N N T) is found. Go to the S Y S t e m directory and find R E G E D T 3 2. E X E, select it to the dialog and click the "OK" button. The Registry Editor is launched, and all configuration units are displayed in different laminate windows, respectively. 2) Select "Window" menu item H k e y _ L O c a l _ m a c h i n e, its sub-window display. Maximize this window for use. 3) Tree control using the left window is positioned to S Y S Y T E M / C U R R E N T C O N T R O L SE / S q L e C U.. Click this subkey to select it, display its value in the right window. 4) Make sure that Local System Account and Administrator Group have complete control of this and their subtries. The timeout time of configuring the SQL Server asynchronous query process
All SQL Server DB-Library Asynchronous Query Processing requests have built-in sleep time. In some cases, this may have a negative impact on performance. System administrators can change sleep times by changing registry: 1) Open the Start menu and select "Run". Click the "Browse" button to start navigation until the root directory of Wi N D O W S2 0 0 0 (usually W I N N T) is found. Go to the S Y S t e m directory and find R E G E D T 3 2. E X E, select it to the dialog and click the "OK" button. The Registry Editor is launched, and all configuration units are displayed in different laminate windows, respectively. 2) Select "Window" menu item H k e y _ L O c a l _ m a c h i n e, its sub-window display. Maximize this window for use. 3) Tree control using the left window is positioned to S O f T Wa R E / M I C R O S O f T / m s S q L S e R / D b - L i E N T / D B - L I b. Click this subkey to select it, display its value in the right window. 4) The entry is positioned to the value D A t a r e a d y s l e e p. Setting the value of D WO R D Editor to set D A T A R E A D Y S L EE P for a lower value required. The hint value D A t a r e a d y s L e E P value ranges from 0 to 1 0 0 0, the default value is 2 5 0. Set value D A t a r e a d ys l e E P is equal to 0 x f f f f F f F can completely ban sleep. WARNING Settings Value D A T A R E A D Y S L E E P is equal to 0 or even execution of the asynchronous query process.
Prevent SQL Server's web server connection is reset
Sometimes, if SQL Server is requested by several customers, the connection is reset. One way to solve this problem is to change the registry in accordance with the following steps: 1) Open the Start menu and select "Run". Click the "Browse" button to start navigation until the root directory of Wi N D O W S2 0 0 0 (usually W I N N T) is found. Go to the S Y S t e m directory and find R E G E D T 3 2. E X E, select it to the dialog and click the "OK" button. The Registry Editor is launched, and all configuration units are displayed in different laminate windows, respectively. 2) Select "Window" menu item H k e y _ L O c a l _ m a c h i n e, its sub-window display. Maximize this window for use. 3) Use the tree control of the left window to locate the S O F T WA R E / M I C R O S O F T WA R E / M I C R O S O F T / M s S Q L s E R. Click this subkey to select it, display its value in the right window. 4) The entry of the value Wi N S O C K L I S t e n b c k L o g. Setting the value of Wi N S O C Kl I S t e N B A C K L Og with a D WO R D Editor to a higher value until the problem no longer occurs. The value of the prompt value Wi N S O C K L O S e n b A c k L o g ranges from 1 to 0 x f f f F F, the default value is 1 0 0. WARNING Because of the essential reasons, system administrators may have to try, and they can find a suitable setting for Wi N S O c k L.
Configure the replication function of SQL Server
In rare cases, the replication function of SQL Server may not work because of the registry to fail or destroy the entry of the distributed database and its path. To check this problem and resolve, the system administrator must follow the steps below to check the registry: 1) Open the Start menu and select "Run". Click the "Browse" button to start navigation until the root directory of Wi N D O W S2 0 0 0 (usually W I N N T) is found. Go to the S Y S t e m directory and find R E G E D T 3 2. E X E, select it to the dialog and click the "OK" button. The Registry Editor is launched, and all configuration units are displayed in different laminate windows, respectively. 2) Select "Window" menu item H k e y _ L O c a l _ m a c h i n e, its sub-window display. Maximize this window for use. 3) Use the tree control of the left window to position to S O F T Wa R E / M I C R O S O f T / m s S q L S E R V E R / R E P L I C A T I O N. Click this subkey to select it, display its value in the right window. 4) The entry positioned to the value D i S R I B U T I O N D B and WO R K I N G D i R E C T O R Y. Use a string editor to ensure that D i S T R I B U T I O N D B and WO R K I N G D i R E C T O R Y is set to be the correct value. WARNING Only when the fault occurs, only manually editing D i S R k I n g D i r e c t o R y can avoid unpredictable behavior.
