Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-04 : 21:21:55
|
| Jeroentje writes "Database problemI have Microsoft SQL server 2000 running on a Microsoft Windows 2000 Server. My server has a pentium 4 1.4GHz processor and 512Mb Ram.I've got 4 harddisks in a raid configuration.SQL server and Windows 2000 server are installed on a 10Gb partition.The database data are on a seperate partition of 60Gb.The database is used by several Java applications.Here's my problem:At times I notice that the database stops responding.I can't access the database anymore and apparantly it has stopped functioning.All my applications come to a halt.When it starts I notice an increase in memory usage. This will continue for a period of 7 to 10 minutes. After this period my applications will start runningagain on full speed and the memory usage will drop again. But then the CPU usage increases for a while.I have no clue to the origin of this behavior. Could anyone provide me with some help?I would be very grateful." |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-04 : 22:22:55
|
| Does anything coincide with this behavior? Are backups scheduled at the time? How do you know it is SQL and not the application? Have you tried connecting with Query Analyzer when it locks up? Does it happen at the same time every day? Run perfmon and profiler and capture one of these episodes, maybe it will shed some light.-Chad |
 |
|
|
|
|
|
SQL server stops responding