msdb
in [Server Configuration]
|
From: guest5 on 14 Jan 2008 09:51 Hi I have a sql 2005 instance running sp2. The msdb database keeps running out of space and I cant work out what's using all of it. Currently its 1.5 data allocated. The usage report of the trables shows the larges table is only 10Mb! Any advise will be appreciated as to where to start looking. Thanks in advance.
From: Yan on 14 Jan 2008 10:11 Check if the 1.5GB is due to data or log size. If log then it is posible that a large DML operation took place thus causing the log to grow. In addition this is a good article, take a look at the tempdb chapter: http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx ---- "guest5" <guest5(a)discussions.microsoft.com> wrote in message news:876AA104-C30B-451D-9146-69AF9D9EF21E(a)microsoft.com... > Hi > > I have a sql 2005 instance running sp2. The msdb database keeps running > out > of space and I cant work out what's using all of it. Currently its 1.5 > data > allocated. The usage report of the trables shows the larges table is only > 10Mb! > > Any advise will be appreciated as to where to start looking. > > Thanks in advance.
From: guest5 on 14 Jan 2008 10:28 Yan This is purely data. Log is a further 50Mb "Yan" wrote: > Check if the 1.5GB is due to data or log size. If log then it is posible > that a large DML operation took place thus causing the log to grow. > > In addition this is a good article, take a look at the tempdb chapter: > http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx > ---- > > > > "guest5" <guest5(a)discussions.microsoft.com> wrote in message > news:876AA104-C30B-451D-9146-69AF9D9EF21E(a)microsoft.com... > > Hi > > > > I have a sql 2005 instance running sp2. The msdb database keeps running > > out > > of space and I cant work out what's using all of it. Currently its 1.5 > > data > > allocated. The usage report of the trables shows the larges table is only > > 10Mb! > > > > Any advise will be appreciated as to where to start looking. > > > > Thanks in advance. > > >
From: Leon Mayne on 14 Jan 2008 10:35 "guest5" <guest5(a)discussions.microsoft.com> wrote in message news:CD9A92E2-6822-4350-9979-564705637C52(a)microsoft.com... > This is purely data. Log is a further 50Mb If it's all free space in the data file then just use the DBCC shrinkfile command to clear it out.
From: guest5 on 14 Jan 2008 10:42 Hi This is the point. All the data file space is getting used, but unsure what object is using it up as the usage report does not list any tables which are that large. There is again virtually no space on the data file. "Leon Mayne" wrote: > "guest5" <guest5(a)discussions.microsoft.com> wrote in message > news:CD9A92E2-6822-4350-9979-564705637C52(a)microsoft.com... > > This is purely data. Log is a further 50Mb > > If it's all free space in the data file then just use the DBCC shrinkfile > command to clear it out. >
|
Next
|
Last
Pages: 1 2 3 Prev: Database Maintenance Plan Wizard Next: copying stored procedures in SQL Server 2005? |