Still on the topic of automating maintenance tasks.. consider the following monthly security patch maintenance steps on 100+ SQL Servers with 500+ databases:

1. install monthly security patches on all mirror...

natural reaction to high stress/high impact working environments.... when trading systems are down there will be profanity... lots of it.

.. main reason why IT in the finance industry is dominated by males...

back in the days of mainframe programming, COBOL, Natural, Fortran etc, there were a lot more woman programmers. IMO this was due to the structured training programs and courses that...

Ok, so at them moment I have an unsent log of 4090945 KB and current restore rate of 2574 KB/sec which gives me an estimated 25 minute lag.

Wait stats on...

No, the DR server is totally passive and we dont run any database or disk snapshots.

Murphys Law now that I want to pull some wait stats the server is 100%...

In fact I have a server where this is happening right now. Same error as you:

.

.

A time out occurred while waiting for memory resources to execute the query

Resource Monitor (0xaa0)...

it can be a combination of issues. Perhaps check what your tempdb utilisation is too.

We get your error ocasionally on some of our servers where we do very intensive Service...

perhaps if you implement a 24x7 server-side trace you will be able to capture the offending code or batch:

http://www.mssqltips.com/tip.asp?tip=1841

Microsoft has their own internal knowledge base consisting of KBs and customer incidents and requests for PSS, MCS staff, system engineers etc to query and reference. Most of this information...

In my post I'm referring to physical servers. We only ever install 1 instance of SQL Server per server. Oracle is a little different.

Another thing I must mention is...

I have a team of 4 DBAs - 2 SQL and 2 Oracle. We manage administer:

270 SQL Servers -dev, test, UAT and production

70 Oracle on Linux servers - dev,...

Nice one - thanks. My suspicions were correct - Service Broker:

(No column name)MBs_Used

sysdesend19140

sysdercv14279

sysconvgroup7216

queue_messages_8838738418

Looks like something to do with SENDs and RECEIVEs.

I worked for Microsoft 2001 - 2004 at their MSN offices in Soho, London. We had a great mix of young talented system engineers, DBAs and PMs and it was...

awww! I thought this article was on soft skills... badly needed in the DBA community. 😀