Leo.Miller (5/12/2010)

---

Also where in the index are these 2 columns? If they aren't the first 2 columns you are doing a table or clustered index SCAN, of 8 million rows.

Send...

I tried something like the one below.

SELECT wt.session_id,wt.wait_duration_ms,wt.wait_type,

st.text

FROM sys.dm_os_waiting_tasks wt LEFT JOIN sys.dm_exec_requests er

ON wt.waiting_task_address = er.task_address

OUTER...

You can try using proxy account.

http://www.sql-server-performance.com/articles/dba/sql_server_job_proxy_account_p1.aspx

Is it because someone is directly updating the subscriber database?

I guess these are sporadic issues related to job schedules. Is there something we might be missing here?

I am getting little confused.

Is there any script which you could share with us for use in SQL Server 2000

As these are at the instance level, I doubt it.

Thanks Jason, for your quick response 🙂

Really appreciate it.

Thanks Jason,

I am working on generating the Performance dashboard reports (PDR) on my server and we are looking for reseting the counters without restarting the instance.

Would clearing these counters...

David,

Thanks for this wonderful article. Please share your comments.

1) Could we do this on SQL server 2000

2) Is there a way by which we can track at which point the...

chrisph (3/30/2010)

---

Some things I would check would be:

1. SQL Server Configuration Manager - is the FullText Search service running properly (set to Automatic and actually running)?

2. In the specific Database...

Thanks

I tried below options and it worked.

GRANT VIEW SERVER STATE TO user

GRANT ALTER TRACE TO user

Rem,

I...

I remember seeing a similar post. May be you could check this

http://www.sqlservercentral.com/Forums/Topic851669-146-1.aspx