|
Home > Archive > microsoft.public.cert.exams.mcse > June 2002 > Required Memory for SQL
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Required Memory for SQL
|
|
| LOCUTUSSS 2002-06-23, 6:25 pm |
| Hi,
I have a question about can any one help and answer it.
I have an SQL server that when querys are sent to it alot, most of them will
time out.
I need to find out how much (exactly) memory I need for the machine to keep
SQL running with no time outs on the Queries.
Thanxs
| |
| Roger Abell [MVP] 2002-06-28, 1:25 am |
| "LOCUTUSSS" <Graham_Rock@Hotmail.com> wrote in message
news:eVhpA7wGCHA.2596@tkmsftngp10...
> Hi,
> I have a question about can any one help and answer it.
>
> I have an SQL server that when querys are sent to it alot, most of them
will
> time out.
>
> I need to find out how much (exactly) memory I need for the machine to
keep
> SQL running with no time outs on the Queries.
>
> Thanxs
>
>
I believe you have the wrong question for solving your problem.
IOW throwing memory at it is not always the solution.
User Query Analyzer to analyze your query (doh!), and then
optimize the query itself and/or the indexing on the tables involved.
If you still have issues, look at size/placement of tempdb and ram.
Run the profiler to give you a view over aggregate runtime behavior
when under a load from the optimized queries.
--
Roger Abell
MS MVP (Windows Platform), MCSE, MCDBA
Associate Expert - Windows XP ExpertZone
http://www.microsoft.com/windowsxp/expertzone
|
|
|
|
|