Performance differ between two server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Performance differ between two server

Author

Topic

radha
Starting Member

11 Posts

Posted - 2005-04-15 : 03:21:00

hi,
I have a performance problem.Actually my job is running weakly once.
but it's taking long time.In that job Iam executing Stored Procedures.

For checking purpose,i executed the stored Procedure manually in two server.Server "A" taking short time.But Server "B" taking long time.
I have checked the database size and table size ,everything is same for Server A and Server B.

But Server A -->If i right click the Database and Check the properties.In that Available size on disc is 94.9 MB.

But in Server B -->If i right click the Database and Check the properties.In that, Available size on disc is 0 MB.I think beacuse of that,How to increase the Available size.
Help me
Bye

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-04-15 : 08:28:54

From Books Online:

quote:

E. Modify a file
This example increases the size of one of the files added to the Test1 database in Example B.

USE master
GO
ALTER DATABASE Test1
MODIFY FILE
(NAME = test1dat3,
SIZE = 20MB)
GO

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources