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 |
|
alexstefa
Starting Member
1 Post |
 Posted - 2010-03-26 : 13:28:38
|
| Hi,we have a serious problem with a software (Zucchetti – Ad Hoc Revolution) based on SQL Server.The server is HP Proliant DL 380 G5, 6 Gb RAM and Xeon Quad Core.The Operating system is Windows Server 2k8 R2 64Bit and SQL Server 2008 Sp2 64 bitWe have some delay to view the results of the query, for example lists of documents.When the problem occurs, the software shows for 2- 3 minutes the message “query in progress...” and sometimes, during the problem, other clients connected to the database also have the program frozen.During the trouble the reply of ping from SQL server is normal (< 1ms).During the problem we use network drive, outlook and other applications hosted from the same server where is installed the database, without any problems.The event viewer of SQL server doesn’t show any errors and, during trouble, the monitoring tool of server 2k8 is without errors (RAM CPU LAN DRIVE ok!)The problem happens randomically.Below, I list the tests I did:1) Upgraded RAM and CPU assigned to SQL;2) Reinstalled all clients that use the program;3) Reinstalled SQL Server;4) Trough Remote Desktop, we run the program installed on the server where the database is.The problem still goes on, any suggestion?Does exist a software to understand if it is a network or a SQL Server problem? |
|
|
|
|
|
|
|
Problem with Query