Shark Energy,

Looks like you are having some fun here

[font="Courier New"]

Yes, you can add 2 or more log files to a database without loosing log shipping and mirroring but my question to you is why? There isn't any gain...

Let me first ask this. Have you enabled the TF 845 for the SQL Server 2008 R2 Std edition instances as well to use the Locked Pages in memory for...

[font="Verdana"]

Alexander,

I think we have identified the problem. SQL Server is memory hungry beast and doesn't play nice when you have 2 instances competing for memory if you don't set the...

[font="Verdana"]

Can you share some information if the box is stand alone or a VM? SELECT @@VERSION would help.

Do you use OPENXML, extented procedures, sp_OA* etc in your environment? Have you...

[font="Courier New"]Taylor,

I agree with you that relying on memory and commenting on the post is NOT only difficult but extremely prone to errors. To go back to the actual question,...

CirquedeSQLeil (7/27/2010)

---

I would look into doing the rebuilds more frequently and more targeted.

I would rebuild certain tables on certain nights and have a rebuild job running nightly.

Example:

TableA - monday night

TableB...

[font="Courier New"]

Few random thoughts.

Faster tempDB potentially RAID10, more RAM.

Or take the overhead of creating a custom partition in the old fashioned way using multiple tables and a view with a...

Brian Huse (7/23/2010)

---

I've also tried the following

SET @ExecStr = 'DBCC INPUTBUFFER(' + STR(@@SPID) + ')'

INSERT INTO #inputbuffer

EXEC (@ExecStr)

SET @Qry = (SELECT EventInfo FROM #inputbuffer)

which works, but requires everyone...

ashaaban (7/22/2010)

---

Thanks guys for your help. I did set the max server memory to use by sql server to 14 GB. I think that will help but I dont...

[font="Courier New"]

In this post, I have listed the query as well as all the events traced in the default trace. Basically the default trace id is 1 NOT 0.

...

[font="Courier New"]

Your best bet is to use Event Notifications and look for the specific events you are interested in.

Jonathan Kehayias has done a very good write up on Event Notifications...

jeff.mason (7/21/2010)

---

And in addition, that isn't going to solve the core issue which is that the memory utilization is too high. He'll just slam against 4 GB instead of...

jeff.mason (7/21/2010)

---

Take a 16 GB SQL Server and limit it to 4 GB for SQL to use? Even giving 2 GB to the OS (seems a bit high to...

WayneS (7/20/2010)

---

Now, where I differ. I'm assuming that since you're running 2000 ent, that you are also running on older hardware. Probably old enough to be near it's end-of-life also.

So,...