I did the changes in my database. but I am getting following alerts

DATE/TIME: 2/18/2009 10:51:11 AM

DESCRIPTION: The SQL Server performance counter 'Data File(s) Size (KB)' (instance 'PEP') of object...

Can you give more details on this ?

Shall I crease 500 Mb ? or shall I keep 100 MB ?

Thanks

ichbinraj

Thanks guys, 🙂

I am using 2005 Enterprise edition I have 90 GB table which need to be index on-line.. so I am planning to do it with no downtime. ...

Yes, its processor and datafile ration.

Server has only 1 Database size 2 tb. I have completed adding ndf file successfully.

Thanks

ichbin

We have recommendations from team- lead to increase the datafiles in db ...he suggested us to maintain ratio 2:1 (datafiles :Processors ). thats what I am planning to do ?...

I really appreciate your information.

I will look into sys table and dmvs ..

Thanks

ichbin