Memory

• Mairim Odara

  SSC Enthusiast

  Points: 113

  More actions

  January 25, 2005 at 4:40 am

  #102364

   

  Hi,

  I'm using a query on -table- open- query.

  My tables have 2 indexes. The first, in "CLIENT" colummn is clustered. The second, in "DATE" is not clustered.

  I have Administration Access.

  I observed some situations when I try to execute queries:

  1. When I start a system is possible to execute, for example, this query:

  SELECT     CLIENT, CAST(MONTH(DATE) AS VARCHAR(2)) + '/' + CAST(YEAR(DATE) AS CHAR(4)) AS MONTHYEAR, VT AS VRT

  FROM         R713  GROUP BY CLIENT, CAST(MONTH(DATE) AS VARCHAR(2)) + '/' + CAST(YEAR(DATE) AS CHAR(4)), VRT

  I have no problem

  But, if I try the same with INSERT "timeout expired" error appears

  2. The same SELECT in View can be executed no problem.

  3. During execution of the query, Sqlservr.exe uses 700 MB physical memory. After the execution or "timeout expired" message appears, sqlservr.exe keeps using 700MB(more or less) of the physical memory and don't available it for another processes.

   Can you help me, again, please??????

  Thanks, very much

  Mairim

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  January 25, 2005 at 5:43 am

  #538917

  I would check for blocking processes on the table that you are trying to insert the records into. The blocking condition would cause the insert to timeout.

  ---

  
  Shamless self promotion - read my blog http://sirsql.net