msdb
in [Server Configuration]
|
From: Leon Mayne on 14 Jan 2008 10:46 "guest5" <guest5(a)discussions.microsoft.com> wrote in message news:0593FF8A-3570-4A63-A657-7AD1E07B1E02(a)microsoft.com... > 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. Something is probably adding lots of data, which increases the data file size, and then deleting the data, which leaves the data file the same size but removes the data from inside it, thus you are left with a large but empty data file.
From: TheSQLGuru on 14 Jan 2008 10:51 1) contrary to what someone else suggested, you should probably NOT shrink the file. Search the web for karazi don't shrink sql. 2) You should (almost) NEVER run out of space in a database if you have autogrowth set correctly. 3) sp_spaceused does NOT reflect accurate values unless you recently run dbcc updateusage. See BOL. 4) do you perchance have a lot of databases or are you doing frequent backups (or maybe restores? 5) Do you have any third-party product on the server which could be using msdb? -- Kevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net "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 12:31 Hi Kevin I ran dbcc update usage and the sp_spaceused values are unchanged see below. There aer 13 databases on server inc system databases. We are using vb maintenance scripts for the maintenance jobs. Obviously something is using all the space but the disk usage reports for tables does not indicate what is taking up the space. Quite confusing. database_name database_size unallocated space -------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------ msdb 1540.00 MB 0.07 MB reserved data index_size unused ------------------ ------------------ ------------------ ------------------ 1535928 KB 1484808 KB 49176 KB 1944 KB "TheSQLGuru" wrote: > 1) contrary to what someone else suggested, you should probably NOT shrink > the file. Search the web for karazi don't shrink sql. > > 2) You should (almost) NEVER run out of space in a database if you have > autogrowth set correctly. > > 3) sp_spaceused does NOT reflect accurate values unless you recently run > dbcc updateusage. See BOL. > > 4) do you perchance have a lot of databases or are you doing frequent > backups (or maybe restores? > > 5) Do you have any third-party product on the server which could be using > msdb? > > -- > Kevin G. Boles > Indicium Resources, Inc. > SQL Server MVP > kgboles a earthlink dt net > > > "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: Tibor Karaszi on 14 Jan 2008 13:34 Does below give any hints? USE msdb SELECT TOP(30) OBJECT_NAME(object_id), rows FROM sys.partitions ORDER BY rows DESC -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "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 15 Jan 2008 08:32 Hi It returns. Not sure how to check the size. Any advise? queue_messages_407672500 563042 queue_messages_407672500 563042 "Tibor Karaszi" wrote: > Does below give any hints? > > USE msdb > SELECT TOP(30) OBJECT_NAME(object_id), rows > FROM sys.partitions > ORDER BY rows DESC > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > "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. >
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 Prev: Database Maintenance Plan Wizard Next: copying stored procedures in SQL Server 2005? |