Hi,

No my exact requirement is that i want to automate this work.i want to take backup of all the object script on daily basis for all the producation databases on...

HI All,

Thanks for your replies.I am going through Gail's article on server side trace.here is link.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

And i am also going through DMV's.

Thanks,

Akshay

Hi,

No i have not yet set MAX memory.but it will work??

and according to you how much memory do i set for SQL & how much for OS?

Thanks,

Akshay

Hi Gail,

Thanks for your reply.I will go through it.In case of any query i will get back to you.

Thanks,

Akshay

Hi Roy,

My DB files(mdf.ldf)is located on local drive.Does LDF file size make any impact on DML& DDL operations????

Because ldf file size for each of the database is above 100GB.

Thanks

Akshay

Hi,

I have searched for PLE counter in perfmon.can you please suggest me where i can locate that counter??

Thanks

Akshay

Hi Roy,

Yes i am getting 6261 error on particular column.Thanks for reply.I will make some changes & will contactyou in case of any queries.

Thanks

Akshay

Hi roy,

yes there are some user defined datatypes.can you please explain how they are affecting my update statistics maintenance plan??

Thanks,

Akshay

HI,

Have you applied service pack on SQL Server 2008??

Apply service pack on fresh installation & then try saving maintenance plan.

Akshay G.

I am using Win server ent edition

Thanks & regards,

Akshay G

Nitin,

I have not applied Service pack3 or 4 yet because i m waiting for management approval for the same.

I have not enabled AWE.