Yes Its cluster based.

Hey Luis - The Auto update stats is set to true already. But The CPU and no of reads for the bad plan is more and taking over all CPU...

Thanks for the reply's.

There was a heavy usage on the tables and manually updating stats is resolving this issue. Its happening frequently so i thinking to implement.

So thinking to trigger...

steve,

Thanks for the reply

I need the information of last two-three months. is there any way to find it?

Backups are of only 7 days.

Thanks Guys.

I am able to connect to sql server by using port number as suffix during login.

The SQL Server browser is enabled on one server and not on other

But i...

thanks Guys. On one of the server browser is running and on the other server it is not.

I am getting the same results on both the servers.

How about the SQL server 2000 version?

Thank you guys for the reply's. Really Appriciate them

Lowell script worked like charm. modified little

SELECT r.name,dbs.DatabaseName

FROM master.sys.server_principals r

JOIN...

It is a 64bit VM server.

AWE option is checked.

Is this is the reason for using more memory?

take a back up once.

then perform DBCC shrink command.

Thanks for your suggestion.

Will follow this.

Do we need to restart the server or services after changing the new max memory on the production server.

I guess it dynamically changes. please let...

yes you are right, we are moving physically.

we are moving our servers to diff location

Thanks a lot for your reply's

Thanks a lot for your reply's