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 - 2001-07-02 : 13:10:44
|
| rama writes "Dear sir,I have a question regarding to SQL Server clustering.My database specifications are as below:The database file size is 1,995,200kb, called Hal2000_data.mdfTempdb.mdf which is 8192kb.2. Current physical memory is 1,006636, Physical memory - total 1047968Available 18980File cache 19676Commit ChargeTotal 1006658Limit 3097100Peak 10217203. Version 7, service pack 2, - no hot fixes.4. No other applications - other than anti virus software.The problem is,at certain point of time users are able to retrive the data by querying in 10 sec. Wheras at some other time the same querying takes 40 secs. When the SQL Server is running on failover the same problem occurs. When we restart the system the problem seems to be solved but temprorarily. Again the same problem occurs. Could you please give me a solution to the problem?" |
|
|
|
|
|
SQL Server problem in cluster