HI all,
I have a pentium 4 3.GIG dual processor 1GIG ram server, that has Exchange
5.5 and MSDE 2000. Are their any bad side effects to this setup. That is,
speed issues, load etc. Will the current setup support this.
Thanks
Robert
hi Robert,
Robert Bravery wrote:
> HI all,
> I have a pentium 4 3.GIG dual processor 1GIG ram server, that has
> Exchange
> 5.5 and MSDE 2000. Are their any bad side effects to this setup. That
> is, speed issues, load etc. Will the current setup support this.
usually Exchange is not a good companion for SQL Server... it is supported,
but if you can afford separated boxes.... :D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||HI Andrea,
THanks for the info. I'm trying to isolate some networking problems. Re- my
repvious post concerning MSDE, which you answered. What I am trying to
figure out is that if MSDE is on the same box as Exchange, would I
experience offline and connections dropping from client pc's. The server in
question is a pIV3.0gig, 1gig RAM, raid5, 180gig free HD
THanks
Robert
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3sbpu5Fn2vgmU1@.individual.net...
> hi Robert,
> Robert Bravery wrote:
> usually Exchange is not a good companion for SQL Server... it is
supported,
> but if you can afford separated boxes.... :D
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
Showing posts with label ram. Show all posts
Showing posts with label ram. Show all posts
Friday, March 30, 2012
Monday, February 20, 2012
MSDB Growing Weekly
Hello All.
We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
72.2 SCSI Hot Plug Server
We run over this server OLTP (3 databases), and OLAP (4 databases)
processes, the server performs okey but we have this issue:
Our MSDB grows about 150% weekly the only "solution" we have found is to
stop restart services in order to get MSDB small againg.
We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
get our OLAP solution updated, also a daily full backup is executed (to
disk) for all databases including master and msdb.
We have executed the following tip with no results.
[b]You can remove old backup and restore records from the MSDB database
by
running the sp_delete_backuphistory stored procedure, like this
USE msdb
EXEC sp_delete_backuphistory '01/01/00'[/b]
If anyone have had this solved with a better solution instead of stopping
restarting services Ill be very gratefull at you.!!!
RegardsChristian,
Are the DTS packages updated often? These and their many versions are stored
in msdb. Look at sysdtspackages table. If you do not delete the previous
version and keep adding new versions this will fill msdb.
Chris Wood
Alberta Department of Energy
CANADA
"Christian A. Tello" <ctello@.oiecuador.com.ec> wrote in message
news:uZNZVJ%23GEHA.2416@.TK2MSFTNGP12.phx.gbl...
> Hello All.
> We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
> 72.2 SCSI Hot Plug Server
> We run over this server OLTP (3 databases), and OLAP (4 databases)
> processes, the server performs okey but we have this issue:
> Our MSDB grows about 150% weekly the only "solution" we have found is to
> stop restart services in order to get MSDB small againg.
> We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
> get our OLAP solution updated, also a daily full backup is executed (to
> disk) for all databases including master and msdb.
> We have executed the following tip with no results.
> [b]You can remove old backup and restore records from the MSDB databas
e by
> running the sp_delete_backuphistory stored procedure, like this
> USE msdb
> EXEC sp_delete_backuphistory '01/01/00'[/b]
>
> If anyone have had this solved with a better solution instead of stopping
> restarting services Ill be very gratefull at you.!!!
> Regards
>|||Thanks Chris
In fact we did that 8 or 9 weeks ago we deleted all versions. We modify
the certain DTS 4 times a month. At this time we have 94 rows within the
sysdtspackages table. We have 28 DTSs.
Any other ideas?
Thanks again
****************************************
Christian,
Are the DTS packages updated often? These and their many versions are
stored
in msdb. Look at sysdtspackages table. If you do not delete the previous
version and keep adding new versions this will fill msdb.
Chris Wood
Alberta Department of Energy
CANADA
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!
We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
72.2 SCSI Hot Plug Server
We run over this server OLTP (3 databases), and OLAP (4 databases)
processes, the server performs okey but we have this issue:
Our MSDB grows about 150% weekly the only "solution" we have found is to
stop restart services in order to get MSDB small againg.
We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
get our OLAP solution updated, also a daily full backup is executed (to
disk) for all databases including master and msdb.
We have executed the following tip with no results.
[b]You can remove old backup and restore records from the MSDB database
by
running the sp_delete_backuphistory stored procedure, like this
USE msdb
EXEC sp_delete_backuphistory '01/01/00'[/b]
If anyone have had this solved with a better solution instead of stopping
restarting services Ill be very gratefull at you.!!!
RegardsChristian,
Are the DTS packages updated often? These and their many versions are stored
in msdb. Look at sysdtspackages table. If you do not delete the previous
version and keep adding new versions this will fill msdb.
Chris Wood
Alberta Department of Energy
CANADA
"Christian A. Tello" <ctello@.oiecuador.com.ec> wrote in message
news:uZNZVJ%23GEHA.2416@.TK2MSFTNGP12.phx.gbl...
> Hello All.
> We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
> 72.2 SCSI Hot Plug Server
> We run over this server OLTP (3 databases), and OLAP (4 databases)
> processes, the server performs okey but we have this issue:
> Our MSDB grows about 150% weekly the only "solution" we have found is to
> stop restart services in order to get MSDB small againg.
> We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
> get our OLAP solution updated, also a daily full backup is executed (to
> disk) for all databases including master and msdb.
> We have executed the following tip with no results.
> [b]You can remove old backup and restore records from the MSDB databas
e by
> running the sp_delete_backuphistory stored procedure, like this
> USE msdb
> EXEC sp_delete_backuphistory '01/01/00'[/b]
>
> If anyone have had this solved with a better solution instead of stopping
> restarting services Ill be very gratefull at you.!!!
> Regards
>|||Thanks Chris
In fact we did that 8 or 9 weeks ago we deleted all versions. We modify
the certain DTS 4 times a month. At this time we have 94 rows within the
sysdtspackages table. We have 28 DTSs.
Any other ideas?
Thanks again
****************************************
Christian,
Are the DTS packages updated often? These and their many versions are
stored
in msdb. Look at sysdtspackages table. If you do not delete the previous
version and keep adding new versions this will fill msdb.
Chris Wood
Alberta Department of Energy
CANADA
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!
MSDB Growing Weekly
Hello All.
We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
72.2 SCSI Hot Plug Server
We run over this server OLTP (3 databases), and OLAP (4 databases)
processes, the server performs okey but we have this issue:
Our MSDB grows about 150% weekly the only "solution" we have found is to
stop restart services in order to get MSDB small againg.
We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
get our OLAP solution updated, also a daily full backup is executed (to
disk) for all databases including master and msdb.
We have executed the following tip with no results.
You can remove old backup and restore records from the MSDB database by
running the sp_delete_backuphistory stored procedure, like this
USE msdb
EXEC sp_delete_backuphistory '01/01/00'
If anyone have had this solved with a better solution instead of stopping
restarting services Ill be very gratefull at you.!!!
Regards
Christian,
Are the DTS packages updated often? These and their many versions are stored
in msdb. Look at sysdtspackages table. If you do not delete the previous
version and keep adding new versions this will fill msdb.
Chris Wood
Alberta Department of Energy
CANADA
"Christian A. Tello" <ctello@.oiecuador.com.ec> wrote in message
news:uZNZVJ%23GEHA.2416@.TK2MSFTNGP12.phx.gbl...
> Hello All.
> We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
> 72.2 SCSI Hot Plug Server
> We run over this server OLTP (3 databases), and OLAP (4 databases)
> processes, the server performs okey but we have this issue:
> Our MSDB grows about 150% weekly the only "solution" we have found is to
> stop restart services in order to get MSDB small againg.
> We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
> get our OLAP solution updated, also a daily full backup is executed (to
> disk) for all databases including master and msdb.
> We have executed the following tip with no results.
> You can remove old backup and restore records from the MSDB database by
> running the sp_delete_backuphistory stored procedure, like this
> USE msdb
> EXEC sp_delete_backuphistory '01/01/00'
>
> If anyone have had this solved with a better solution instead of stopping
> restarting services Ill be very gratefull at you.!!!
> Regards
>
We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
72.2 SCSI Hot Plug Server
We run over this server OLTP (3 databases), and OLAP (4 databases)
processes, the server performs okey but we have this issue:
Our MSDB grows about 150% weekly the only "solution" we have found is to
stop restart services in order to get MSDB small againg.
We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
get our OLAP solution updated, also a daily full backup is executed (to
disk) for all databases including master and msdb.
We have executed the following tip with no results.
You can remove old backup and restore records from the MSDB database by
running the sp_delete_backuphistory stored procedure, like this
USE msdb
EXEC sp_delete_backuphistory '01/01/00'
If anyone have had this solved with a better solution instead of stopping
restarting services Ill be very gratefull at you.!!!
Regards
Christian,
Are the DTS packages updated often? These and their many versions are stored
in msdb. Look at sysdtspackages table. If you do not delete the previous
version and keep adding new versions this will fill msdb.
Chris Wood
Alberta Department of Energy
CANADA
"Christian A. Tello" <ctello@.oiecuador.com.ec> wrote in message
news:uZNZVJ%23GEHA.2416@.TK2MSFTNGP12.phx.gbl...
> Hello All.
> We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
> 72.2 SCSI Hot Plug Server
> We run over this server OLTP (3 databases), and OLAP (4 databases)
> processes, the server performs okey but we have this issue:
> Our MSDB grows about 150% weekly the only "solution" we have found is to
> stop restart services in order to get MSDB small againg.
> We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
> get our OLAP solution updated, also a daily full backup is executed (to
> disk) for all databases including master and msdb.
> We have executed the following tip with no results.
> You can remove old backup and restore records from the MSDB database by
> running the sp_delete_backuphistory stored procedure, like this
> USE msdb
> EXEC sp_delete_backuphistory '01/01/00'
>
> If anyone have had this solved with a better solution instead of stopping
> restarting services Ill be very gratefull at you.!!!
> Regards
>
Subscribe to:
Posts (Atom)