|
Home > Archive > MS SQL Server > March 2006 > Virtual hard disk
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]
|
|
| guoqi zheng 2006-03-05, 8:24 pm |
| Hi,
My database server runs very slow. It is only 100-200MB at this moment. And
should not be exceeding 300MB because old data is deleted everyday.
Some one recommend me to use virtual hard disk to improve the performance.
The idea is use RAM as a hard disk to run SQL server. Access to RAM will be
much faster than access to phycial hard disk.
Use RAM as hard disk, is this a good idea? can how can I do this? any
recommendation for software to use?
regards,
Guoqi Zheng
http://www.ureader.com
| |
|
|
| Guoqi Zheng 2006-03-05, 8:24 pm |
|
> If it is only 300MB or less in size then it should be totally in memory
> anyway as long as you have plenty of memory on your machine.
What does it mean? Now I often see from "performance monitor" that memory
and disk are running at 100%! Are you saying that if I increase the memory,
SQL will save lots of data in memory anyway?
Thanks for all those reference, I am reading them now. I have found the most
of time comsuming queries I have are those which doing data paging on web
page.
| |
| Tibor Karaszi 2006-03-06, 7:23 am |
| That sounds like a strange suggestion. You would waste your RAM on such a virtual disk, since SQL
Server would cache frequently accessed data anyhow (and if you use such a virtual disk, the same
data will live twice in RAM: in SQL Server's cache and in the RAM disk). Tune your queries and
indexes so that an operation utilizes as few resources as possible.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"guoqi zheng" <no@sorry.com> wrote in message news:8dc5579f2690415
2aa437c5afc116a3c@ur
eader.com...
> Hi,
>
> My database server runs very slow. It is only 100-200MB at this moment. And
> should not be exceeding 300MB because old data is deleted everyday.
>
> Some one recommend me to use virtual hard disk to improve the performance.
> The idea is use RAM as a hard disk to run SQL server. Access to RAM will be
> much faster than access to phycial hard disk.
>
> Use RAM as hard disk, is this a good idea? can how can I do this? any
> recommendation for software to use?
>
> regards,
>
> Guoqi Zheng
> http://www.ureader.com
| |
| Guoqi Zheng 2006-03-06, 7:23 am |
| Thanks for your response.
Do you think there is a way to tell SQL server which data to cache and which
don't? I think my SQL cache too much data which does not necessary be
cached. But I do know some data need to be cached! Can I control the cache
myself?
"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
message news:ecTAgWPQGHA.5592@TK2MSFTNGP11.phx.gbl...
> That sounds like a strange suggestion. You would waste your RAM on such a
virtual disk, since SQL
> Server would cache frequently accessed data anyhow (and if you use such a
virtual disk, the same
> data will live twice in RAM: in SQL Server's cache and in the RAM disk).
Tune your queries and
> indexes so that an operation utilizes as few resources as possible.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
> Blog: http:// solidqualitylearning
.com/blogs/tibor/
>
>
> "guoqi zheng" <no@sorry.com> wrote in message
news:8dc5579f2690415
2aa437c5afc116a3c@ur
eader.com...
And[color=darkred]
performance.[color=darkred]
be[color=darkred]
>
| |
| Tibor Karaszi 2006-03-06, 7:23 am |
| You can specify max memory that the SQL Server can use. If you don't, SQL Server will us the
available memory in your machine (and back off if some other process need memory so the machine
otherwise would start paging). Apart from that, SQL Server manages by itself what data to keep in
cache, more or less the same as all caching systems does.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"Guoqi Zheng" <no@sorry.com> wrote in message news:440c25bf$0$1256
8$c3e8da3@news.astraweb.com...
> Thanks for your response.
>
> Do you think there is a way to tell SQL server which data to cache and which
> don't? I think my SQL cache too much data which does not necessary be
> cached. But I do know some data need to be cached! Can I control the cache
> myself?
>
> "Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
> message news:ecTAgWPQGHA.5592@TK2MSFTNGP11.phx.gbl...
> virtual disk, since SQL
> virtual disk, the same
> Tune your queries and
> news:8dc5579f2690415
2aa437c5afc116a3c@ur
eader.com...
> And
> performance.
> be
>
>
| |
| Andrew J. Kelly 2006-03-06, 7:15 pm |
| Yes if you have enough memory to fit the entire set of data that you use
most often in SQL Servers cache it will only have to go to disk when it
writes the log or data to disk. All reads will come directly from memory
and not touch the disk at all one the data has been read the first time. If
you have a GB or more of memory on your machine this should not be
occurring.
--
Andrew J. Kelly SQL MVP
"Guoqi Zheng" <no@sorry.com> wrote in message
news:440b6aa1$0$4313
$c3e8da3@news.astraweb.com...
>
>
> What does it mean? Now I often see from "performance monitor" that memory
> and disk are running at 100%! Are you saying that if I increase the
> memory,
> SQL will save lots of data in memory anyway?
>
> Thanks for all those reference, I am reading them now. I have found the
> most
> of time comsuming queries I have are those which doing data paging on web
> page.
>
>
|
|
|
|
|