I wanted to Find out what actually is causing server running slow.

When we tested Stored Procedures individually ,they are fine.

May be problem with Batch jobs or any other maintenance plans.

Thats...

I also had same problem with collation settings.

The error message was conflict with collation settings.

Many of them suggested me to Rebuild Master Database with New...

Hi Everybody, eve ni have same issues with 32 Bit & 64 Bit Server. I'll come up clearly with issues in a day or two.

Can you please tell me where can you see page count.

we are not shrinking databases

I think you can try back up GUI . I guess it should not ask for any User Id or PSSWD.

After Rebuilding Indexes on tables , tables are getting fragmented

next day automatically.

We are thinking of running Physical Disk Defragmentation.

I am sorry if i am wrong.

Most of the tables are more than 2000 rows

What are the things that i need to check out in Execution Plan.

I don't have idea about , how to look...

I guess your server does not allow remote access. Check out in your

Connections.

The Path you mentioned is not clear. Can you please repost this.

Good Job Vijay & appreciate your sharing attitude.

Please continue posting such in future too.

Thanks for your reply. I'll get back to you if any issues further.

Hey Friend,

Do i need to do anything else apart from those mentioned.

What could be Validations for this upgradation from 80 to 90 for testing.

I had Executed both the Queries against the User DB

sp_updatestats

-DBCC UPDATEUSAGE (0);

The following was part of Result.

DBCC UPDATEUSAGE: counts updated for...

Thanks for your reply.

But at present there is only one Database in this server.