colin Leversuch-Roberts (7/29/2008)

---

well I think the official ms figure is 300 although I prefer a higher value. If the page life goes to zero then you're flushing the cache and...

colin Leversuch-Roberts (7/29/2008)

---

that's really the wrong set of data and question. Why do you think you don't have enough memory?

I'd suggest you start with page life expectancy - this will...

No, the undo file contains info to recover the database, ie. undo uncommitted transactions.

Using the DBCC command, I find that the log space utilization for tempdb is about 43%, but, what do I do next?

jeffrey yao (7/28/2008)

---

When serveral big inserts are combined in one transaction, there is a "hot" demand for the log space. Without "begin tran / commit tran", as soon as one...

I changed my post above to include a COMMIT TRAN (had a ROLLBACK TRAN earlier).

Same outcome:

With the transaction, the query completes in about 15 min.

Without the transaction (with BEGIN...

No worries, it's much appreciated.

Perfmon counter "Buffer Manager\Page life expectancy" is below 200. I think that indicates memory pressure as well.

I'm also seeing a lot of SP:CacheRemove events in Profiler. Is the cache being flushed because of memory pressure?

Also:

We appear to be under phys. memory pressure on the server: RAM utilization is 14 GB (out of a total of 16 GB).

The instance is configured with AWE (Lock working...

Thanks guys, I'm flattered.

Will start work on the article! 😀

Mazharuddin Ehsan (7/26/2008)

---

My inputs based on working on both the dbs:

1. SQL Server 2005 is eqally good as Oracle 10g in performance etc.

2. The other parameters you can...

TheSQLGuru (7/26/2008)

---

Marios, could I trouble you for the table definitions for your system as well as the rdl for the report(s) you have? Looks like some very useful stuff...

This is a great link for identifying the various contributors to tempdb utilization:

Working with tempdb in SQL Server 2005

http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx#EX1AE

Based on that link, I have created the following sproc that is...

Amit Chaudhary (7/24/2008)

---

Hi,

I have to check whether Named Pipes and TCP/IP is enabled or not on 89 SQL Servers ( all are 2005 ). I am planning to use sqlcmd....