ooo ok, I will have a look thanks 🙂

Oh right yes if I try to capture those queries running longer than the cost threshold then I know which ones will be running parallelism, correct?

Hi I am in a similar situation to you in that I am just getting into performance tuning. I have found this a great article:

http://sqlcat.com/whitepapers/archive/2007/11/19/sql-server-2005-waits-and-queues.aspx

Ok thanks I will check it out. Also will try to kick as many people of as possible from test server :p

Ah yes, thanks

Ok well for anyone interested it I have done some more local testing and it seems that if you are trying to overwrite a database using a backup of a...

well the databases reside on the same server. Basically the file paths were:

E:\Data\db.mdf and E:\Test\Data\db.mdf

There is no permission problems that I can see so does your theory still...

Have just found this article which explains how to use the Audit Schema Object Access event class. This is a far better way of doing this as it shows...

Hi again Gail

Thinking about this then maybe I should only profile the table name adding the filter to the TextData column, seeing as Object name and ID relate to the...

So that explains why I get lots of rows that seem irrelevant because the trace pulls back things it can't identify as having an object name.

In fact in my trace...

Ok cool - please see below 🙂

<deadlock-list>

<deadlock victim="processee711c18">

<process-list>

<process id="processff0ef8" taskpriority="0" logused="1580" waitresource="KEY: 38:72057594054508544 (1404d11120e3)" waittime="3171" ownerId="5176117985" transactionname="user_transaction" lasttranstarted="2010-12-17T09:07:01.937" XDES="0xeaf66370" lockMode="X" schedulerid="4" kpid="8808" status="suspended" spid="337"...

Hi thanks for the reply. How can I see whats currently accessing that index? I am having a mental block on this.

Thanks

Ahh I see well thanks for clearing that up for me 🙂

wow great I am looking for a decent forum for DBAs in regards to Sharepoint. I may have beaten you to the first post however 😀

Ok I have got myself in a tiz about device CALs now!!

How does a web front end not qualify for a device CAL when all external users will be going...