CCS Point of Sale
You are here: start » guides » maintenance » start » sql_server
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
guides:maintenance:start:sql_server [2011/02/21 00:34] markphillips |
guides:maintenance:start:sql_server [2018/12/23 12:17] (current) |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| SQL Server is the database program that CCS uses to store data. Under a variety of circumstances SQL Server can slow down the computer and use too many resources. This document provides information on how to fix these circumstances. | SQL Server is the database program that CCS uses to store data. Under a variety of circumstances SQL Server can slow down the computer and use too many resources. This document provides information on how to fix these circumstances. | ||
| - | [[guides:maintenance:start:sql_server#Error No connection to Server|Error No connection to Server]] | + | [[guides:maintenance:start:sql_server#Error No connection to Server|Error No connection to Server]]\\ |
| + | [[guides:maintenance:start:sql_server#Sluggish System|Sluggish System]] | ||
| ===== Error No connection to Server ===== | ===== Error No connection to Server ===== | ||
| Line 12: | Line 13: | ||
| Start - All Programs - SQL Server - SQL Server Configuration Manager | Start - All Programs - SQL Server - SQL Server Configuration Manager | ||
| - | Make sure the SQL Server is running. | + | Make sure the SQL Server is running. You can right click on the SQL Server service to start it running. |
| === SQL Server 2000 === | === SQL Server 2000 === | ||
| From the task tray in the bottom of the Windows Toolbar, make sure that SQL Server is running. If it is not, double click on it and press play from the SQL Server Window. | From the task tray in the bottom of the Windows Toolbar, make sure that SQL Server is running. If it is not, double click on it and press play from the SQL Server Window. | ||
| + | ===== Sluggish System ===== | ||
| + | |||
| + | If you find that all your computers are running slow it might be the server running SQL Server that is the culprit. Check Task Manager to see the amount of memory SQL Server is taking up.\\ | ||
| + | |||
| + | Press Ctrl + ALT + DEL\\ | ||
| + | |||
| + | If the SQL Server is taking up more than 500-600 megabytes, then it may need to be restarted. You can do this by following the steps provided earlier to access SQL Server\\ | ||
| + | |||
| + | {{:guides:maintenance:sql:taskmanager.png|}} | ||
| + | |||
| + | |||
| + | [[guides:maintenance:start:sql_server#Error No connection to Server|Error No connection to Server]] | ||
Trace:
