Currently, without /3GB, AWE, or LPIM enabled, the query returns this:

TotalGB,VASGB,Buffer Committed,Buffer Target

4.00,2.00,1.56,1.56

Page life is averaging under one minute so I'm hoping these changes will help.

I'd be happy to run that query. It will be a while though because the production system I'm looking at isn't scheduled for a restart until the end of...

Thanks for all the great information.

The Microsoft rep that we have on site this week confirmed that enabling AWE and LPIM on the 4gb RAM 32bit system would allow SQL...

Thanks George, would this server benefit from "Lock pages in memory" or enabling AWE? Will enabling AWE have an affect on 32 bit servers with only 4GB ram?

Running outside the sp, it completes in 1 - 2 seconds but has a message in the execution plan that adding a new index could improve performance.

Adding the index as...

Thanks for the replies. Interestingly with or without parameters, it still executes very slowly when inside the SP.

Going to look at the execution plan both ways tomorrow to see if...

Execution plans look identical. SQL Server must be deciding the best way to handle it.

Found it in Options/Keyboard

Listed under Debug.Start

It was F5 global and Alt+F5 in query editor. Wonder why it was changed.

F5 has always been refresh.

Thanks for helping me to understand.

I see now that if I give a user read only permission and they attempt to update a table, it will log a...

SQL Server 2008 Audit allows auditing of a number of things including select/insert/update/delete. It is working properly for capturing these events to the Windows Application or event log but it...

The problem was that the cluster nics had become unteamed so there was a significant amount of packet loss. When fixed, the errors went away.

Thank you for the reply.

Thanks everyone. The queries and suggestions really helped. In the end, it was not that complex of a join but the database (Microsoft Project Portfolio Server) is hugely...

Thanks Jeff, poking around in the tables gave me some clues and then I opened a new database diagram and added the tables and then was able to see where...

muhammadrazzaqpk-1032285 (12/9/2011)

---

Hey Howard, I can create job easily - Job creation is not a problem, I did execute the script you sent me, it did create the job but when...