Problem in enterprise manager

Question

Post reply

Problem in enterprise manager

Oracle_91

SSChampion

Points: 14548
More actions
May 15, 2011 at 11:15 am

#97942

Hi,
I have scenario where in the SQL Server 2000 Enterprise Manager shows up "Space Avialable" = 0.0MB.
There is sufficient space at OS level.
I really dont have any clue. In sql server ERROR log, nothing is logged.
Thought it is something autogrowth problem. I manually increased 512 mb for the data file and again it was working.
My SQL 2000 is on SP3 service pack level?
why GUI shows 0.0MB as space available?
Is this a known issue or what does it mean and what all scenario's Enterprise manager will show up as 0.0 MB.
Any help would be greatly appreciated.
Thanks in Advance.

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

The maxsize of the data file can cause this.

Increase the size of the database.

You can modify in EM or in Query Analyzer:

http://msdn.microsoft.com/en-us/library/ms175890.aspx

USE master;

GO

ALTER DATABASE AdventureWorks2008R2

MODIFY FILE

(NAME = data1,

SIZE = 500MB);

GO

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Oracle_91 SSChampion Points: 14548 More actions · Answer 2

Hi Welsh,

Thanks for the quick response.

How does the maxsize of the data file effects this???

Could you please elaborate with an example.

Am really wanted to know why this happens.

Thanks in Advance.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

Oracle_91 (5/15/2011)
How does the maxsize of the data file effects this???
Could you please elaborate with an example.
Am really wanted to know why this happens.

If the maxsize is specified on a database then it can't grow beyond that size.

You do not have to specify the maxsize.

Each time the database reaches the the maxsize you have to increase the size of the database.

Listed below is a link to an article that provides some examples:

http://msdn.microsoft.com/en-us/library/aa275464(v=sql.80).aspx

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Oracle_91 SSChampion Points: 14548 More actions · Answer 4

Hi Welsh,

Both data and log files are set to unrestricted file growth and it is a cluster. There is lot of disk space available in the shared drive.

Thanks

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

It does not matter how much disk space is available.

You need to check the size of the database and increase it.

How to increase the size of a Database:

http://msdn.microsoft.com/en-us/library/aa197143(v=sql.80).aspx

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Oracle_91 SSChampion Points: 14548 More actions · Answer 6

Database growth is also fine.

My question was is there any such scenario where in Enterprise manager shows 0.0Mb.

Any known issue of Enterprise Manager.

Thanks.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 7

You can check out the size of the database. You can use sp_helpdb.

Then you simply need to increase the size of the database.

If you are maxed out then users can't use the database.

How are you getting by? You have to be down unless non one is using the database.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Oracle_91 SSChampion Points: 14548 More actions · Answer 8

Thats what am wondering, it is not showing any event logged in SQL Server error log nor Application log.

Users reported that they were not able to save data.

I went into Enterprise mgr and increased 512 and saw and everything is fine.

But i didnt understand why it was showing 0.0Mb.

Thanks.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 9

Oracle_91 (5/15/2011)
Users reported that they were not able to save data.
I went into Enterprize mgr and increased 512 and saw and everything is fine.
But i didnt understand why it was showing 0.0Mb.
.

What you need to worry about is how much space has been allocated for the database and is there enough disk space.

You did the right thing. In crease the size of the database, monitor the size and then worry about what all of the option mean.

Do you have any books on this that you may be using to to study for the Microsoft Exam?

If not check out a bookstore.

Regards,

Welsh

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Oracle_91 SSChampion Points: 14548 More actions · Answer 10

Thanks Welsh.

That was really motivating.

I am new to sql. I will buy some books and study.

Thanks once again.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 11

I tried to help you?

Are you good to go for now?

Regards,

Welsh

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Oracle_91 SSChampion Points: 14548 More actions · Answer 12

yup. Thank you.

Now there's no problem. Just wanted to knw why GUI shown like that.

I dnt even see any err messages like below.

"

Could not allocate new page for database '<db>'. There are no more pages available in filegroup PRIMARY. Space can be created by dropping objects, adding additional files, or allowing file growth..

"

no such messages.

Thanks for your help.