home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.paradox      To crash or not to crash, asks Borland      9,834 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 9,184 of 9,834   
   Larry DiGiovanni to Trevor   
   Re: SQL access very slow in Paradox 9 HE   
   29 Apr 08 13:47:45   
   
   From: nospam@nospam   
      
   Trevor wrote:   
      
   > Any other ideas?   
      
      
   1.  Have a DBA monitor your connection while the 15-20 minute operation is   
   occurring to diagnose what the server utilization (cpu, disk, I/O) is.   
   Could be a configuration issue, such as lack of space in tempdb.   
   2.  Have a network engineer analyze the traffic.  Ideally compared to when   
   the old server was in use.   
   3.  Open and scrutinize an ODBC trace on the connection.  Again, ideally   
   compared to when the old server was in use.   
      
   Is the old server still available to test with?   
   Are the non-Paradox related activities not impacted at all?  Can you perform   
   similar actions on the database in, say, Access?  Are direct query   
   operations (e.g., Query Analyzer) impacted at all?   
      
   --   
   Larry DiGiovanni   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca