August 16, 2010 at 4:36 am
Hi all,
While inquirying a big-size buffered query, system crashes and exports an error to event viewer
"General Network Error"
How do i handle this?
System Memory: 8GB
SQL Server Max Memory : 6GB
SQL2K5 Standart Edition...
Waiting your responses.
August 16, 2010 at 4:58 am
seems like the query you running having lots of record. Can you try running your query first with top 100 or .. and then see the execution plan to check where the max time is getting utilised.
----------
Ashish
August 16, 2010 at 6:06 am
Agree with Ashish.
Try reconstructing guery to commit more regularly (run in smaller chunks). If possible you may want to consider restarting your instance and then running query straight away (before anything else grabs memory).
Adam Zacks-------------------------------------------Be Nice, Or Leave
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply