Memory

Hi, Experts
I have a sql server 7 on NT4.0 box.
2GB memory for the server.
Recently we can not do tape back up during the night.
we check CPU load is normal, but memory sql sever process
uses up to 1.5 GB of the 2GB. Is this normal?
It used to not take that much.
And the biggest database on that box is only 400MB.
Any advice.
Thanks
Laopangthis could be because of memory leaks, what service pack
you are running ? Is it possible for you to upgrade to sql
2000 or atleast upto sp4 for sql 7?
restart the server to resolve this temporarily.
hth
>--Original Message--
>Hi, Experts
>I have a sql server 7 on NT4.0 box.
>2GB memory for the server.
>Recently we can not do tape back up during the night.
>we check CPU load is normal, but memory sql sever process
>uses up to 1.5 GB of the 2GB. Is this normal?
>It used to not take that much.
>And the biggest database on that box is only 400MB.
>Any advice.
>Thanks
>Laopang
>.
>|||SQL Server will not release memory once it has grabbed it unless the OS
specifically asks for it. Just because the db is of a certain size does not
limit the amount of ram sql server can use. Sounds like it can easily get
away with using less so I suggest you set the MAX memory for sql server to
say 1GB and see how that works.
--
Andrew J. Kelly
SQL Server MVP
"laopang" <laopang@.hotmail.com> wrote in message
news:0cfd01c3b383$5b42d4a0$a001280a@.phx.gbl...
> Hi, Experts
> I have a sql server 7 on NT4.0 box.
> 2GB memory for the server.
> Recently we can not do tape back up during the night.
> we check CPU load is normal, but memory sql sever process
> uses up to 1.5 GB of the 2GB. Is this normal?
> It used to not take that much.
> And the biggest database on that box is only 400MB.
> Any advice.
> Thanks
> Laopang

Media set

Hi All
I would like to know in detail about the differences between back up set,
media set, media family, devise etc. Can any one provide link to resourses
where I can find that. In BOL it is bit confusing.
Thanks in Advance
R.DAn image tell more than a thousand words.
Using Media Sets and Families
http://msdn.microsoft.com/library/d... />
t_70oj.asp
AMB
"R.D" wrote:

> Hi All
> I would like to know in detail about the differences between back up set,
> media set, media family, devise etc. Can any one provide link to resourses
> where I can find that. In BOL it is bit confusing.
> Thanks in Advance
> R.D|||> An image tell more than a thousand words.
Keep up with the news. You should soon say:
An varbinary(max) tell more than a thousand words.
<g>
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:4549A302-23DF-4E5C-BBE1-AF1D26E43C17@.microsoft.com...
> An image tell more than a thousand words.
> Using Media Sets and Families
> http://msdn.microsoft.com/library/d...>
rst_70oj.asp
>
> AMB
> "R.D" wrote:
>|||Media Sets and Families
Media sets comprise several individual media. All media in a media set
should be of the same type. For example, a 200-GB database might span 3
tapes. The 3 tapes are considered to be a media set.
A media family refers to the collection of media used by an individual
backup device. For example, if a 2-TB database is backed up using 4 tape
drives (with 5 tapes in each drive), each set of 5 tapes is considered to be
a media family. Collectively the 20 tapes would be considered a media set.
[url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx[
/url]
Aleksandar Grbic
MCDBA, Senior Database Administrator
"R.D" wrote:

> Hi All
> I would like to know in detail about the differences between back up set,
> media set, media family, devise etc. Can any one provide link to resourses
> where I can find that. In BOL it is bit confusing.
> Thanks in Advance
> R.D|||Tibor,
This is good. I am happy to start a new w with some humor.
AMB
"Tibor Karaszi" wrote:

> Keep up with the news. You should soon say:
> An varbinary(max) tell more than a thousand words.
> <g>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in messag
e
> news:4549A302-23DF-4E5C-BBE1-AF1D26E43C17@.microsoft.com...
>