MS SQL Server 2005 hang
in [Server Configuration]
|
Prev: Permissions Needed to Count SSB Transmission Queue Messages
Next: How to Call an SSIS package from SQL-server.
From: Patrick on 18 Jun 2010 07:10 Hi, Did you get any solution to your problem. I'm experiencing the same kind of problem on one server with 16GB memory and a partitionned table... My SELECT (even very simple one) will freeze from time to time even if I'm the only one connected to the database. The same query will need one second to execute and will never terminate if executed some minutes later... There is no CPU issue, no blocking... don't know where to look for... Thanks Patrick From http://www.developmentnow.com/g/118_2007_5_0_0_977543/MS-SQL-Server-2005-hang.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/
From: Erland Sommarskog on 18 Jun 2010 17:17
Patrick (patrick.fiche(a)aqsacom.com) writes: > Did you get any solution to your problem. > I'm experiencing the same kind of problem on one server with 16GB memory > and a partitionned table... > My SELECT (even very simple one) will freeze from time to time even if > I'm the only one connected to the database. > The same query will need one second to execute and will never terminate > if executed some minutes later... > There is no CPU issue, no blocking... don't know where to look for... How did you verify that there is no blocking? What does "SELECT @@version" return? -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx |