January 21, 2005 at 4:31 am
Please, I nedd your help
Hi,
I have a DB with some tables conteints 10 000 000 records (more or less) each one. When I try to execute some queries, "Timeout expired" errors occurs. For Example:
A query Insert From: INSERT INTO R713_SUM (CLIENT, MONTHYEAR, VAL)
SELECT CLIENT, CAST(MONTH(DATE) AS VARCHAR(2)) + '/' + CAST(YEAR(DATE) AS CHAR(4)) AS MONTHYEAR, SUM(VAL) AS VALT
FROM R713
Table R713 conteins 8500000 records.
Can you help me?
Thanks
Mairim
January 21, 2005 at 6:02 am
I would start with what application are you using for the INSERTs (have you checked the timeout or changed it)
Have you reviewed your indexes to make sure no fragmentation, they are still working? i.e. no table scans, etc...
Have you reviewed the load on your server to make sure no blocks/locks?
Good Hunting!
AJ Ahrens
webmaster@kritter.net
January 21, 2005 at 8:15 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply