It's rather Process (not Connection) has status "Suspended"

(as per BOL: "The session is waiting for an event, such as I/O, to complete").

You should analyze (as it was suggested) sys.dm_exec_requests (and...

Jim,

Eventually these 2 dates calculation is the same as (I supressed the rest):

select

dateadd(m, 9, '2010-12-31 00:00:00.000'), --7

dateadd(m, 9, '2010-12-30 00:00:00.000') --8

Result is the same-...

Jeremy,

Sorry, but frankly I confused with your recommendation "Keep the witness in the same site as your principal database"

(and certainly I know that per BOL MS "We strongly recommend that...

As Steve mentioned if you would like to do this in regular basis you can use partitioning

Can only speculate that he meant Upgrade Advisor: http://www.microsoft.com/download/en/details.aspx?id=11455

But certainly only your Manager knows for sure 🙂

Can be many different reasons.

IMO try to identify top tables by size first (DB- right click- reports- standard reports), then- what (apps) and why adds data to theses tables.

This can...

You can Export report into XML file after it was created

Yes, you are right- one needs simply to adjust backup interval depending on DB size. Thanks

Make sense.

I have though 1 more question-

your backup job runs every 15 min (on primary server) and deals with 130 DBs,

i.e. avg backup time should be around 7...

Hi Brian,

Just curious- if all 130 DBs reside on the same server why you did not consider using clustering?

Thanks, Yuri

Now it makes...

Gail,

Can you please clarify this a bit unusual case (I mean Full-TrLog-Diff backups)?

Let's assume there were no transactions during backups (only some inserts between Full and TrLog as originally stated).

Can...

Probably:

select id, type from myTbl where id in (select id from myTbl where type ='A')

if I did not miss something

From my experience to isolate issue- 1) check report script (SP, etc)- how fast, number of records returned;

2) check report with smaller input range, i.e. only few output records. This...

It seems you need to add another User to Content Manager role.

Check this link- hope can help:

http://msdn.microsoft.com/en-gb/library/ms156034.aspx (How to: Grant User Access to a Report Server (Report...