Connection Fails after 2 or 3 hours later?
-
Hi everybody,
i ve installed SQL 2000 5 months ago . it was running perfectly. but nearly 1 month ago it started to fail connecting DB 2-3 hours later.
When it occurs;
RAM usage is 1.68GB of 2GB
10 users connect to DB
after i restart the SQL server it is ok for 2-3 hours. RAM usage goes well (400 MB of 2GB) . 2-3 hours later the same thing occurs...
what is the problem, why does this occur after 4 months later ???
Why the RAM goes up?
Thnx for your help,
-
Without knowing your system, problems often arise in SQL databases over time due to the increase in data. 5 months ago, your database was new and now it has 5 months of data in it. Queries that may have worked well with test data sometimes fail when actual data is input due to the distribution and indexing problems.
As a rule, SQL craves memory. SQL attempts to cache as much information in memory as it can. It also tries to use memory for @Table variables and the like. It is normal for SQL to increase its memory usage after rebooting.
Generally, though, connectivity issues aren't related to memory but something else. Next time you are unable to connect kill one of the SPID for the users and see if 1 more user can now connect. Maybe there is something happening when the 11th user tries to connect?
-
thank you JeffB,
i tried to establish a connection using Enterprice manager but i get this error :
"Connection Failed. Check Sql Server registration properties" . So the connection has lost. i couldn't access the data or anything else. SP3 is already installed. and i downloaded and install the Sp4 today. if i get the error again i'll reinstall
if you have words, please share,
Fatih Ender
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply