here's the stored procedure that most of the times cause time out. on the previous messages u said that some clustered indexes should be defined on related tables. I'd like...

I had run a profiler trace (standard template) but no recommendation is reported by DTS!! and only 38% of the trace is analyzed then it stops reporting errors!!

yes it is

What's the amount of physical RAM on the windows server, how much is in use and how much is in...

I rebuilt indexes and updated statistics however that values for worker thread etc is as follow:

name ...

One more point:

I've come at work on weekend to check the server, today no one is using that server because its holiday. But still the sqlserver is so slow...

I've run a server side trace. now, when I want to open it in DTS for analyzing it says the file is in use. I tried to stop and close...

I've rebuilt indexes and run sp_updatestats then I executed following to find 10 most consumers of CPU:

SELECT TOP 5 (total_logical_reads/execution_count) as avg_logical_reads, (total_logical_writes/execution_count) as avg_logical_writes, (total_physical_reads/execution_count) as avg_phys_reads, Execution_count,...

I'm back with the same problem

Let me explain the whole problem better.

The sqlserver is slow generally; everything with its database is slow and of course when that stored procedure...

That was a helpful comment thank you Brandie 🙂 I'm using enterprise architect for reverse engineering

The other thing I'm thinking of is that databases are being modified daily. So...

That was a helpful comment thank you Brandie 🙂

Thanks for the reply:)

I'll start tuning stored proc, etc.

However in reviewing database designs I think I need to know projects well and since the number of projects are high,...

Mohit (3/8/2009)

---

Question ...

Was error similar to this:

TITLE: Microsoft SQL Server Management Studio

------------------------------

Exception has been thrown by the target of an invocation. (mscorlib)

------------------------------

ADDITIONAL INFORMATION:

An error has occurred while establishing a...

I had tried this before but didn't resolve...

1. Select the ID with the select statement

select * from sysmaintplan_plans

2. Replace with the selected ID and run the delete statements

delete from sysmaintplan_log where plan_id = ''

delete from sysmaintplan_subplans where...

I'll do that:)