merge databases

I have 2 database, one has data and one is being created on my handheld. Is there a way to merge the database together so I get the data in the tables I need in the database being create or can I add tables to the existing database so I can use that for my testing?

here is the issue;

database 1 has tables with data - but does not have all the tables I need. - pre-existing

database 2 is being created when I start my app, and creates the tables I need but no data and not all the tables.

Is there a way to merge these to, so I don't have to create a huge insert statements for each tables I need data for?

or can I do a select from database 1 and insert the records into database 2?

example: insert into tbl1 (name) select database 2.table(col1) from tbl1, is this possible?

No. "Huge" insert/select/create statements are needed to do that.

|||how would I do that without creating a new database? How would I create the tables for the existing database?|||To create the tables in the existing database, use the "CREATE TABLE" statement.|||

Good day all,

I too am having the same issue. I have 2 databases with diverging information. The tables should all be identical. I've got different developers adding data to 2 different databases. Rather than re-entering data to one or the other database, I'd like to be able to merge the databases. I am by no means a SQL developer, so i'm not terribly familiar with the T-Sql commandset. If there is any more information on this subject, I will be watching this thread.

Thank you in advance for any assistance!

Merge databases

Hi,
Is it somehow possible to merge two databases with identical schema? We
have two or more sites whose data are supposed to be merged into the
main database at night. Data at each site is unrelated to the data at
other sites. Each site has limited bandwidth (satellite). Some sites
may even lack network, requiring the data to be transported on a DVD-R
from site to main office.
regards,
Knut Eldhuset
You might want to roll your own solution using checksum's or use Red-Gate
software's data compare.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Knut Eldhuset" <knut.eldhuset@.gmail.com> wrote in message
news:1115636465.617229.291830@.g14g2000cwa.googlegr oups.com...
> Hi,
> Is it somehow possible to merge two databases with identical schema? We
> have two or more sites whose data are supposed to be merged into the
> main database at night. Data at each site is unrelated to the data at
> other sites. Each site has limited bandwidth (satellite). Some sites
> may even lack network, requiring the data to be transported on a DVD-R
> from site to main office.
> regards,
> Knut Eldhuset
>

merge database content

hi,

i have a sqlserver CE and a sqlserver database.
The tables are exactly the same on both databases.
the sqlserver CE database Content will be synchronized with the
sqlserver database with insert orders..
is there a way to merge the two databases?
this would be great cause different content will be inserted in both
databases. After a synchronisation both databases should have the same
content..

i hope you understood my problem. my english is not very well..

christianIt sounds like you're looking for merge replication - see Books Online
for more details. Since replication is quite a specialized area, you
might want to post in microsoft.public.sqlserver.replication if you
need more detailed information.

Simon

Merge data in SQL Server databases

I have two databases with identical tables structures. I need to merge the data in both databases without implementing merge replication. Can someone tell me what script to run that will compare the data in those tables? First I know the script has to search for data that doesn't exist in one table, the copy that over from the table that has extra rows. Thanks

AmmieNot sure how to help you unless you want to write a stored proc to do it.

Merge 2 Databases?

My problem is this:

I have a database file on a hard disk. I have to read that data and merge it into a database on a sql server. How can you merge ? The databases are set up the exact same way. The only difference in them is the data.

Also, in the database file I have image names, I have to compare them to what is on the database on the sql server.

Thanks

There are many options.
bcp out and in|||

Not very much data at all. Maybe 500 rows with 10 columns.

I am worried about using DTS because what happens with the foreign keys and primary keys?

Say I have imageID as a primary...and I have imageID 1, 2, 3 in both databases....won't there be conflicts when I run the DTS?

|||

In that case I would go for the good old T-SQL syntax.

You can work cross database.

INSERT INTO myTable (myField, myOtherField)
SELECT myField, myOtherField FROM myOtherDatabase.dbo.myTable

|||

Thanks Wesley for that...

But lets say I have imageID 1, 2, 3 in DB1 and I have imageID 1,2,3 in DB2. Now the images associated to those ID's are totally different. How can I insert the data from DB2 into DB1 without getting errors? I have to somehow increment the ID's in DB2 so they are 3, 4, 5?

|||Takes some logic, you could use a cursor since it's a small recordset and insert the records one by one using SCOPE_IDENTITY to determine the current ID for the child records.

Memory Utilization

Dear all,

One of the server is having 2 GB of RAM and task manager is showing 1.87 GB memory in use.

I have to migrate few databases on the same server.

With high IO Operations.

I know server require more RAM, but how can i prove that server needs more RAM ?

Regards

Mohd Sufian

To 'Prove' it, you need data. These articles will point you in the right direction to get some data.

Performance Audit
http://www.sql-server-performance.com/articles_audit.asp
http://www.sql-server-performance.com/sql_server_performance_audit10.asp

Performance Monitoring
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/operations.mspx Performance WP's
http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx Troubleshooting Performance 2005
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp Hardware Performance CheckList
http://www.sql-server-performance.com/ss_performance_monitoring.asp Practical Solution for Monitoring
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=224587 Troubleshooting App Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp Disk Monitoring
http://sqldev.net/misc/WaitTypes.htm Wait Types
http://support.microsoft.com/?id=271509 Script to Monitor Blocking

Performance Tuning -Articles
http://www.sql-server-performance.com/articles_performance.asp

Performance Tuning –Hardware
http://www.sql-server-performance.com/sg_sql_server_performance_article.asp

|||

You can look at some easy PerfMon counters, such as Buffer Cache Hit Ratio, Page Life Expectancy, and Memory Grants Pending to get a better idea about whether you are seeing memory pressure. Memory pressure will also cause increased IO pressure.

Generally speaking, you can hardly go wrong by adding more RAM to SQL Server, especially if you only have`2GB of RAM installed.

Memory Utilization

Dear all,

One of the server is having 2 GB of RAM and task manager is showing 1.87 GB memory in use.

I have to migrate few databases on the same server.

With high IO Operations.

I know server require more RAM, but how can i prove that server needs more RAM ?

Regards

Mohd Sufian

To 'Prove' it, you need data. These articles will point you in the right direction to get some data.

Performance Audit
http://www.sql-server-performance.com/articles_audit.asp
http://www.sql-server-performance.com/sql_server_performance_audit10.asp

Performance Monitoring
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/operations.mspx Performance WP's
http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx Troubleshooting Performance 2005
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp Hardware Performance CheckList
http://www.sql-server-performance.com/ss_performance_monitoring.asp Practical Solution for Monitoring
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=224587 Troubleshooting App Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp Disk Monitoring
http://sqldev.net/misc/WaitTypes.htm Wait Types
http://support.microsoft.com/?id=271509 Script to Monitor Blocking

Performance Tuning -Articles
http://www.sql-server-performance.com/articles_performance.asp

Performance Tuning –Hardware
http://www.sql-server-performance.com/sg_sql_server_performance_article.asp

|||

You can look at some easy PerfMon counters, such as Buffer Cache Hit Ratio, Page Life Expectancy, and Memory Grants Pending to get a better idea about whether you are seeing memory pressure. Memory pressure will also cause increased IO pressure.

Generally speaking, you can hardly go wrong by adding more RAM to SQL Server, especially if you only have`2GB of RAM installed.

Memory Usage

Hi,
Can anyone tell me whats the best way of determining which databases are
using the most physical memory? I have a server with about 10 ms sql 2000
DB's and the server has 1 gigabyte of ram. The problem is that this memory
is almost always used up by sql and it slows the daily administration down.
I have to keep restarting the sql service which is only a temporary measure.
Thankyou,
Jay.
SQL Server will try to maximize the usage of memory to optimal performance.
If you are operating on 10 different databases then the memory usage and
overhead is on the high. I feel you can allocate more memory for the same.
Instead of restarting you can use the DBCC FREEPROCCACHE and DBCC
DROPCLEANBUFFERS to clear the memory cache. I donot recommend this on
production systems.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"Jay Collen" <jcollen896@.yahoo.com> wrote in message
news:eQv9qIuIEHA.3572@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anyone tell me whats the best way of determining which databases are
> using the most physical memory? I have a server with about 10 ms sql 2000
> DB's and the server has 1 gigabyte of ram. The problem is that this memory
> is almost always used up by sql and it slows the daily administration
down.
> I have to keep restarting the sql service which is only a temporary
measure.
> Thankyou,
> Jay.
>
|||Set your max memory setting to around 700MB and see if that helps.
Andrew J. Kelly SQL MVP
"Jay Collen" <jcollen896@.yahoo.com> wrote in message
news:eQv9qIuIEHA.3572@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anyone tell me whats the best way of determining which databases are
> using the most physical memory? I have a server with about 10 ms sql 2000
> DB's and the server has 1 gigabyte of ram. The problem is that this memory
> is almost always used up by sql and it slows the daily administration
down.
> I have to keep restarting the sql service which is only a temporary
measure.
> Thankyou,
> Jay.
>
|||Thanks for the reply but I simply wish to find out what databases are using
the most resources and how much. I will probably end up having to add more
memory anyway.
Jay.
"Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:ugQj#XuIEHA.3032@.TK2MSFTNGP09.phx.gbl...
> SQL Server will try to maximize the usage of memory to optimal
performance.[vbcol=seagreen]
> If you are operating on 10 different databases then the memory usage and
> overhead is on the high. I feel you can allocate more memory for the same.
> Instead of restarting you can use the DBCC FREEPROCCACHE and DBCC
> DROPCLEANBUFFERS to clear the memory cache. I donot recommend this on
> production systems.
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinf...2000/books.asp
>
> "Jay Collen" <jcollen896@.yahoo.com> wrote in message
> news:eQv9qIuIEHA.3572@.TK2MSFTNGP10.phx.gbl...
2000[vbcol=seagreen]
memory
> down.
> measure.
>
|||Hi,
I agree with Andrew, To add on. check the Virtual memory allocated as well.
If the virtual memory is less then
go for 1048 MB.
One more thing , i feel that there is no option to find out the physical
memory usage per database. Procedure
cache usage can be identified by querying master..sysprocesses table.
Thanks
Hari
MCDBA
"Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
news:O3pdAguIEHA.3444@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Set your max memory setting to around 700MB and see if that helps.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Jay Collen" <jcollen896@.yahoo.com> wrote in message
> news:eQv9qIuIEHA.3572@.TK2MSFTNGP10.phx.gbl...
2000[vbcol=seagreen]
memory
> down.
> measure.
>
|||You cannot get specific Database memory usage as you have asked. You would
have one set for the server level only.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"Jay Collen" <jcollen896@.yahoo.com> wrote in message
news:O%23GGZhuIEHA.3988@.tk2msftngp13.phx.gbl...
> Thanks for the reply but I simply wish to find out what databases are
using[vbcol=seagreen]
> the most resources and how much. I will probably end up having to add more
> memory anyway.
> Jay.
>
> "Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
> news:ugQj#XuIEHA.3032@.TK2MSFTNGP09.phx.gbl...
> performance.
same.[vbcol=seagreen]
are
> 2000
> memory
>

Memory Usage

Hi,
Can anyone tell me whats the best way of determining which databases are
using the most physical memory? I have a server with about 10 ms sql 2000
DB's and the server has 1 gigabyte of ram. The problem is that this memory
is almost always used up by sql and it slows the daily administration down.
I have to keep restarting the sql service which is only a temporary measure.
Thankyou,
Jay.SQL Server will try to maximize the usage of memory to optimal performance.
If you are operating on 10 different databases then the memory usage and
overhead is on the high. I feel you can allocate more memory for the same.
Instead of restarting you can use the DBCC FREEPROCCACHE and DBCC
DROPCLEANBUFFERS to clear the memory cache. I donot recommend this on
production systems.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Jay Collen" <jcollen896@.yahoo.com> wrote in message
news:eQv9qIuIEHA.3572@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anyone tell me whats the best way of determining which databases are
> using the most physical memory? I have a server with about 10 ms sql 2000
> DB's and the server has 1 gigabyte of ram. The problem is that this memory
> is almost always used up by sql and it slows the daily administration
down.
> I have to keep restarting the sql service which is only a temporary
measure.
> Thankyou,
> Jay.
>|||Set your max memory setting to around 700MB and see if that helps.
Andrew J. Kelly SQL MVP
"Jay Collen" <jcollen896@.yahoo.com> wrote in message
news:eQv9qIuIEHA.3572@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anyone tell me whats the best way of determining which databases are
> using the most physical memory? I have a server with about 10 ms sql 2000
> DB's and the server has 1 gigabyte of ram. The problem is that this memory
> is almost always used up by sql and it slows the daily administration
down.
> I have to keep restarting the sql service which is only a temporary
measure.
> Thankyou,
> Jay.
>|||Thanks for the reply but I simply wish to find out what databases are using
the most resources and how much. I will probably end up having to add more
memory anyway.
Jay.
"Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:ugQj#XuIEHA.3032@.TK2MSFTNGP09.phx.gbl...
> SQL Server will try to maximize the usage of memory to optimal
performance.
> If you are operating on 10 different databases then the memory usage and
> overhead is on the high. I feel you can allocate more memory for the same.
> Instead of restarting you can use the DBCC FREEPROCCACHE and DBCC
> DROPCLEANBUFFERS to clear the memory cache. I donot recommend this on
> production systems.
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
>
> "Jay Collen" <jcollen896@.yahoo.com> wrote in message
> news:eQv9qIuIEHA.3572@.TK2MSFTNGP10.phx.gbl...
2000[vbcol=seagreen]
memory[vbcol=seagreen]
> down.
> measure.
>|||Hi,
I agree with Andrew, To add on. check the Virtual memory allocated as well.
If the virtual memory is less then
go for 1048 MB.
One more thing , i feel that there is no option to find out the physical
memory usage per database. Procedure
cache usage can be identified by querying master..sysprocesses table.
Thanks
Hari
MCDBA
"Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
news:O3pdAguIEHA.3444@.TK2MSFTNGP11.phx.gbl...
> Set your max memory setting to around 700MB and see if that helps.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Jay Collen" <jcollen896@.yahoo.com> wrote in message
> news:eQv9qIuIEHA.3572@.TK2MSFTNGP10.phx.gbl...
2000[vbcol=seagreen]
memory[vbcol=seagreen]
> down.
> measure.
>|||You cannot get specific Database memory usage as you have asked. You would
have one set for the server level only.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Jay Collen" <jcollen896@.yahoo.com> wrote in message
news:O%23GGZhuIEHA.3988@.tk2msftngp13.phx.gbl...
> Thanks for the reply but I simply wish to find out what databases are
using
> the most resources and how much. I will probably end up having to add more
> memory anyway.
> Jay.
>
> "Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
> news:ugQj#XuIEHA.3032@.TK2MSFTNGP09.phx.gbl...
> performance.
same.[vbcol=seagreen]
are[vbcol=seagreen]
> 2000
> memory
>

Memory Usage

Hi,
Can anyone tell me whats the best way of determining which databases are
using the most physical memory? I have a server with about 10 ms sql 2000
DB's and the server has 1 gigabyte of ram. The problem is that this memory
is almost always used up by sql and it slows the daily administration down.
I have to keep restarting the sql service which is only a temporary measure.
Thankyou,
Jay.SQL Server will try to maximize the usage of memory to optimal performance.
If you are operating on 10 different databases then the memory usage and
overhead is on the high. I feel you can allocate more memory for the same.
Instead of restarting you can use the DBCC FREEPROCCACHE and DBCC
DROPCLEANBUFFERS to clear the memory cache. I donot recommend this on
production systems.
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Jay Collen" <jcollen896@.yahoo.com> wrote in message
news:eQv9qIuIEHA.3572@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anyone tell me whats the best way of determining which databases are
> using the most physical memory? I have a server with about 10 ms sql 2000
> DB's and the server has 1 gigabyte of ram. The problem is that this memory
> is almost always used up by sql and it slows the daily administration
down.
> I have to keep restarting the sql service which is only a temporary
measure.
> Thankyou,
> Jay.
>|||Set your max memory setting to around 700MB and see if that helps.
Andrew J. Kelly SQL MVP
"Jay Collen" <jcollen896@.yahoo.com> wrote in message
news:eQv9qIuIEHA.3572@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anyone tell me whats the best way of determining which databases are
> using the most physical memory? I have a server with about 10 ms sql 2000
> DB's and the server has 1 gigabyte of ram. The problem is that this memory
> is almost always used up by sql and it slows the daily administration
down.
> I have to keep restarting the sql service which is only a temporary
measure.
> Thankyou,
> Jay.
>|||Thanks for the reply but I simply wish to find out what databases are using
the most resources and how much. I will probably end up having to add more
memory anyway.
Jay.
"Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:ugQj#XuIEHA.3032@.TK2MSFTNGP09.phx.gbl...
> SQL Server will try to maximize the usage of memory to optimal
performance.
> If you are operating on 10 different databases then the memory usage and
> overhead is on the high. I feel you can allocate more memory for the same.
> Instead of restarting you can use the DBCC FREEPROCCACHE and DBCC
> DROPCLEANBUFFERS to clear the memory cache. I donot recommend this on
> production systems.
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>
> "Jay Collen" <jcollen896@.yahoo.com> wrote in message
> news:eQv9qIuIEHA.3572@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > Can anyone tell me whats the best way of determining which databases are
> > using the most physical memory? I have a server with about 10 ms sql
2000
> > DB's and the server has 1 gigabyte of ram. The problem is that this
memory
> > is almost always used up by sql and it slows the daily administration
> down.
> > I have to keep restarting the sql service which is only a temporary
> measure.
> >
> > Thankyou,
> >
> > Jay.
> >
> >
>|||Hi,
I agree with Andrew, To add on. check the Virtual memory allocated as well.
If the virtual memory is less then
go for 1048 MB.
One more thing , i feel that there is no option to find out the physical
memory usage per database. Procedure
cache usage can be identified by querying master..sysprocesses table.
Thanks
Hari
MCDBA
"Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
news:O3pdAguIEHA.3444@.TK2MSFTNGP11.phx.gbl...
> Set your max memory setting to around 700MB and see if that helps.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Jay Collen" <jcollen896@.yahoo.com> wrote in message
> news:eQv9qIuIEHA.3572@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > Can anyone tell me whats the best way of determining which databases are
> > using the most physical memory? I have a server with about 10 ms sql
2000
> > DB's and the server has 1 gigabyte of ram. The problem is that this
memory
> > is almost always used up by sql and it slows the daily administration
> down.
> > I have to keep restarting the sql service which is only a temporary
> measure.
> >
> > Thankyou,
> >
> > Jay.
> >
> >
>|||You cannot get specific Database memory usage as you have asked. You would
have one set for the server level only.
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Jay Collen" <jcollen896@.yahoo.com> wrote in message
news:O%23GGZhuIEHA.3988@.tk2msftngp13.phx.gbl...
> Thanks for the reply but I simply wish to find out what databases are
using
> the most resources and how much. I will probably end up having to add more
> memory anyway.
> Jay.
>
> "Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
> news:ugQj#XuIEHA.3032@.TK2MSFTNGP09.phx.gbl...
> > SQL Server will try to maximize the usage of memory to optimal
> performance.
> > If you are operating on 10 different databases then the memory usage and
> > overhead is on the high. I feel you can allocate more memory for the
same.
> > Instead of restarting you can use the DBCC FREEPROCCACHE and DBCC
> > DROPCLEANBUFFERS to clear the memory cache. I donot recommend this on
> > production systems.
> >
> > --
> > HTH,
> > Vinod Kumar
> > MCSE, DBA, MCAD, MCSD
> > http://www.extremeexperts.com
> >
> > Books Online for SQL Server SP3 at
> > http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
> >
> >
> > "Jay Collen" <jcollen896@.yahoo.com> wrote in message
> > news:eQv9qIuIEHA.3572@.TK2MSFTNGP10.phx.gbl...
> > > Hi,
> > >
> > > Can anyone tell me whats the best way of determining which databases
are
> > > using the most physical memory? I have a server with about 10 ms sql
> 2000
> > > DB's and the server has 1 gigabyte of ram. The problem is that this
> memory
> > > is almost always used up by sql and it slows the daily administration
> > down.
> > > I have to keep restarting the sql service which is only a temporary
> > measure.
> > >
> > > Thankyou,
> > >
> > > Jay.
> > >
> > >
> >
> >
>

Memory Questions

I am running SSAS 2005 SP1 on a machine with Windows 2003 Server R2 and 2 GB of memory.I have approximately 30 analysis databases defined on this machine.

When I process one of my analysis databases, MSMDSRV.EXE gradually takes over 1 GB of virtual memory and does not release it once processing is completed.Once processing completes, MSMDSRV.EXE continues to take up 5-15% of CPU to process something.This goes on for hours.

Let’s say I go into BIDS on this machine and try to open an analysis database by entering the server name then attempting to select a database from the database drop down.It takes about 10 minutes for the list of databases to appear on the screen, and you can watch MSMDSRV.EXE take up more and more virtual memory until it takes over 1 GB of virtual memory.

- Why is SSAS taking up so much virtual memory to perform these operations? Is it metadata overload?

- Is there any way to get MSMDSRV.EXE to release the virtual memory it has taken?

- Once database processing has been completed, what is MSMDSRV.EXE doing that would take 5-15% of CPU?

- Is there a recommended solution to improve memory handling and performance in this situation?

Thanks in advance for your help.

Wendell G.

Is this a recent event or a continual event?

Is the server recognizing the 2gig's of RAM and the full capacity of the processor(s)?

How old is the server?

Adamus

|||

This has been a continual event and has appeared to get worse as more analysis services databases are added to the server.

The server is recognizing the 2 GB ram and is less than one year old.

Wendell G.

|||

Not knowing your situation, the immiteate suggestion is to increase memory of your machine.

2 Gb looks litte on the lower side.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Memory Questions

I am running SSAS 2005 SP1 on a machine with Windows 2003 Server R2 and 2 GB of memory.I have approximately 30 analysis databases defined on this machine.

When I process one of my analysis databases, MSMDSRV.EXE gradually takes over 1 GB of virtual memory and does not release it once processing is completed.Once processing completes, MSMDSRV.EXE continues to take up 5-15% of CPU to process something.This goes on for hours.

Let’s say I go into BIDS on this machine and try to open an analysis database by entering the server name then attempting to select a database from the database drop down.It takes about 10 minutes for the list of databases to appear on the screen, and you can watch MSMDSRV.EXE take up more and more virtual memory until it takes over 1 GB of virtual memory.

- Why is SSAS taking up so much virtual memory to perform these operations? Is it metadata overload?

- Is there any way to get MSMDSRV.EXE to release the virtual memory it has taken?

- Once database processing has been completed, what is MSMDSRV.EXE doing that would take 5-15% of CPU?

- Is there a recommended solution to improve memory handling and performance in this situation?

Thanks in advance for your help.

Wendell G.

Is this a recent event or a continual event?

Is the server recognizing the 2gig's of RAM and the full capacity of the processor(s)?

How old is the server?

Adamus

|||

This has been a continual event and has appeared to get worse as more analysis services databases are added to the server.

The server is recognizing the 2 GB ram and is less than one year old.

Wendell G.

|||

Not knowing your situation, the immiteate suggestion is to increase memory of your machine.

2 Gb looks litte on the lower side.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I have exactly the same situation but I have 12G RAM
each process of the cube increases the memory of the msmdsrv.exe by 2G
eventualy after 4 / 5 processings it fails with a page file % nearly full and the users cannot access. CPU useage by is 13% constant build of sql is 3054 on test server and 3152 on live server both servers have same issue.

Was there an answer to the above appart from more RAM i.e. should the memory be released?

Firts process of cube useage = 951M ,
Second process of cube usage starts at 951M and completes at 2,951M
Third process starts at 2,951 and increases etc and so on till memory all used
Thanks

Memory of sqlserver.exe cannot released

Hi everybody

Help me, Help me.
When I backup the MSSQL databases using ARCServe 2000 in the server, the memory of sqlserver.exe is 1.5G in task manager. After backup was finished, the memory of sqlserver.exe cannot released. It is still 1.5G. Our users can get the resource of that server but they get it slowly. I need to stop and restart the MSSQL service. The server can back to normal.
Can everyone fix it ?

My server is
Windows 2000 Server Standard Edition with SP4
Windows SQL 2000 Standard Edition With SP3
Memory is 2G RAM

Pls Help.
ThanksDo you want to stop and restart (http://msdn2.microsoft.com/en-us/library/ms187598.aspx) SQL Server from a script?

-PatP|||PatP
Thank you for your reply
I got a one problem. I must need to restart the service using password because this is security reason. So, how to write a script with password|||Hi Everybody

I want to reinstall ARCserve 2000 on the server but I lost the license key.
I cannot register it. Can I get or export or read the license key / serial number on existing ARCserve 2000 of server for reinstallation ?

Thank you|||You don't need a password to stop or restart SQL Server. If you are using a Windows Service login, then the password is stored by the service itself. If you need to run the script as a machine administrator, then that password needs to be stored with the Windows Task description. You don't need to code the password into the script, that's a very bad idea and should be avoided.

-PatP|||could the problem be on the arcserv end. i do not know arcserv, but i am wondering if it is leaving connections open or something like that. have you tried opening up profiler to see what is going on?|||Hi Pat
Thanks
A applications is running with connecting the SQL server on that server. If the sql service is restarted, I need to provide two passwords for application to run it. Although the sql service can use the script automatically, the application on that server need to be ran manually every time.

Memory management

I am running SQL 2000 Enterprise SP 3 with Windows 2000 . Our sql
server is running around 5 Databases .. we have Pentium IV and RAM 2 GB .
SQL Server it self takes more than 1.5 GB to 1.6 GB RAM .. it won't reduce m
emory consumption as on connection to sql goes down or no one is connected t
o sql server. SQL Server won't free this ram. we haven't allocated memory fo
r sql server. When we resta
rt the sql server services then the memory consumption goes down to 400 MB.
What may be the cause and what can be done to solve it?Once SQL Server acquires memory, it will retain it unless it is needed by
other applications running on the server. This maximizes performance
because data will remain in cache and memory allocation/deallocation is
costly.
If you routinely run other applications on the same server, consider setting
the max memory for SQL Server,
Hope this helps.
Dan Guzman
SQL Server MVP
"Saleem Subhi" <saleemsubhi_mcs98@.yahoo.com> wrote in message
news:D02C548A-58EE-44CA-9D73-9ADFC9970942@.microsoft.com...

quote:

---

> I am running SQL 2000 Enterprise SP 3 with Windows 2000 . Our sql
> server is running around 5 Databases .. we have Pentium IV and RAM 2 GB

---

.

quote:

---

>
> SQL Server it self takes more than 1.5 GB to 1.6 GB RAM .. it won't reduce

---

memory consumption as on connection to sql goes down or no one is connected
to sql server. SQL Server won't free this ram. we haven't allocated memory
for sql server. When we restart the sql server services then the memory
consumption goes down to 400 MB.

quote:

---

> What may be the cause and what can be done to solve it?

---

Memory management

I am running MS sql 2005 workgroup on a SBS 2003 - R2 server. The only
databases are Sharepoint and Small Business Monitor. SQL is using over 3 gb
of the 4 gb installed in the server. How do I reduce the amount of memory
SQL is using?
MBSSet the MAx Memory setting to the amount you want minus about 300MB and you
should be all set. You can do this via sp_configure or ssms.
--
Andrew J. Kelly SQL MVP
"MBS" <who@.nowhere.com> wrote in message
news:H8CdnbIX_t1gHsvYnZ2dnUVZ_uednZ2d@.suscom.com...
>I am running MS sql 2005 workgroup on a SBS 2003 - R2 server. The only
>databases are Sharepoint and Small Business Monitor. SQL is using over 3 gb
>of the 4 gb installed in the server. How do I reduce the amount of memory
>SQL is using?
> MBS
>

Memory management

I am running SQL 2000 Enterprise SP 3 with Windows 2000 . Our sql
server is running around 5 Databases .. we have Pentium IV and RAM 2 GB .
SQL Server it self takes more than 1.5 GB to 1.6 GB RAM .. it won't reduce memory consumption as on connection to sql goes down or no one is connected to sql server. SQL Server won't free this ram. we haven't allocated memory for sql server. When we restart the sql server services then the memory consumption goes down to 400 MB.
What may be the cause and what can be done to solve it?Once SQL Server acquires memory, it will retain it unless it is needed by
other applications running on the server. This maximizes performance
because data will remain in cache and memory allocation/deallocation is
costly.
If you routinely run other applications on the same server, consider setting
the max memory for SQL Server,
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Saleem Subhi" <saleemsubhi_mcs98@.yahoo.com> wrote in message
news:D02C548A-58EE-44CA-9D73-9ADFC9970942@.microsoft.com...
> I am running SQL 2000 Enterprise SP 3 with Windows 2000 . Our sql
> server is running around 5 Databases .. we have Pentium IV and RAM 2 GB
.
>
> SQL Server it self takes more than 1.5 GB to 1.6 GB RAM .. it won't reduce
memory consumption as on connection to sql goes down or no one is connected
to sql server. SQL Server won't free this ram. we haven't allocated memory
for sql server. When we restart the sql server services then the memory
consumption goes down to 400 MB.
> What may be the cause and what can be done to solve it?