w WARN: Thread pool pressure. Using current thread for a work item.

Posted by GrumpyOldDBA on SQL Blogcasts See other posts from SQL Blogcasts or by GrumpyOldDBA
Published on Mon, 03 May 2010 14:38:53 GMT Indexed on 2010/05/03 16:08 UTC
Read the original article Hit count: 422

Filed under:

diagnostics

|

Trending and Statistics

|

ssrs

The skill set needed by a DBA can be quite diverse at times and a run in with SSRS 2005 probably illustrates the point quite well. I don't have skills in IIS although I was responsible for the design and deployment of an online mortage application site some years ago.I had to get hands on with IIS5, firewalls, intrusion systems, ISA Server, dmzs, NAT, IP and lots of other acronyms so I have an understanding of these things but never had to do anything other than set up and configure IIS - no...(read more)

© SQL Blogcasts or respective owner

Related posts about diagnostics

Add Trace methods to System.Diagnostics.TraceListner

as seen on Stack Overflow - Search for 'Stack Overflow'
I wrote a Log class derived from System.Diagnostics.TraceListener like so public class Log : TraceListener This acts as a wrapper to Log4Net and allows people to use System.Diagnostics Tracing like so Trace.Listeners.Clear(); Trace.Listeners.Add(new Log("MyProgram")); Trace.TraceInformation("Program… >>> More
The Benefits of using Oracle Diagnostics for Oracle Applications

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Listen to Kurt Larsen, Vice President of Oracle Support provide an update on the cost savings and problem avoidance provided to customers using Oracle Diagnostics within the E-Business Suite! >>> More
EBS: How To Install Oracle Diagnostics

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle Diagnostics Support Pack is available as a patch and can be applied using adpatch. Installation is easy. Just follow the steps in Doc ID 167000.1, eBusiness Suite Support - Oracle Diagnostics Support Pack Installation Guide For information on how to run the Diagnostics from a menu within… >>> More
Hello it’s your server calling

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
This is nothing exciting but I've always found this startup procedure very useful. All this simple procedure does is send you an email if the SQL Service Starts. If your Server is a cluster it will tell you which node you're on. -- On it's own this procedure can't actually be… >>> More
Cursors 1 Sets 0

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
I had an interesting experience with a database I essentially know nothing about. On the server is a database which stores session state, Microsoft provide the code/database with their dot net, so I'm told. Anyway this database has sat happily on the production server for the past 4 years I guess… >>> More

Related posts about Trending and Statistics

SQL SERVER – When are Statistics Updated – What triggers Statistics to Update

as seen on SQL Authority - Search for 'SQL Authority'
If you are an SQL Server Consultant/Trainer involved with Performance Tuning and Query Optimization, I am sure you have faced the following questions many times. When is statistics updated? What is the interval of Statistics update? What is the algorithm behind update statistics? These are the puzzling… >>> More
SQL SERVER When are Statistics Updated What triggers Statistics to Update

as seen on Dot net Slackers - Search for 'Dot net Slackers'
If you are an SQL Server Consultant/Trainer involved with Performance Tuning and Query Optimization, I am sure you have faced the following questions many times.When is statistics updated? What is the interval of Statistics update? What is the algorithm behind update statistics? These are the puzzling… >>> More
New Whitepaper: Best Practices for Gathering EBS Database Statistics

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Most Oracle Applications DBAs and E-Business Suite users understand the importance of accurate database statistics. Missing, stale or skewed statistics can adversely affect performance. Oracle E-Business Suite statistics should only be gathered using FND_STATS or the Gather Statistics… >>> More
Incremental Statistics Maintenance – what statistics will be gathered after DML occurs on the table?

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Incremental statistics maintenance was introduced in Oracle Database 11g to improve the performance of gathering statistics on large partitioned table. When incremental statistics maintenance is enabled for a partitioned table, oracle accurately generated global level statistics by aggregating… >>> More
Lies, damned lies, and statistics Part 2

as seen on Oracle Blogs - Search for 'Oracle Blogs'
There was huge interest in our OOW session last year on Managing Optimizer Statistics. It seems statistics and the maintenance of them continues to baffle people. In order to help dispel the mysteries surround statistics management we have created a two part white paper series on Optimizer statistics… >>> More