Viewing 15 posts - 1 through 15 (of 79 total)
Shark Energy,
Looks like you are having some fun here 🙂
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
June 21, 2011 at 10:09 am
[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...
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
April 4, 2011 at 11:28 pm
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="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
March 14, 2011 at 10:06 am
[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="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
March 14, 2011 at 8:27 am
[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"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
March 13, 2011 at 4:22 am
[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,...
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
August 27, 2010 at 11:14 pm
CirquedeSQLeil (7/27/2010)
I would rebuild certain tables on certain nights and have a rebuild job running nightly.
Example:
TableA - monday night
TableB...
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
July 27, 2010 at 9:30 am
[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...
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
July 25, 2010 at 1:07 am
Brian Huse (7/23/2010)
SET @ExecStr = 'DBCC INPUTBUFFER(' + STR(@@SPID) + ')'
INSERT INTO #inputbuffer
EXEC (@ExecStr)
SET @Qry = (SELECT EventInfo FROM #inputbuffer)
which works, but requires everyone...
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
July 24, 2010 at 8:37 pm
ashaaban (7/22/2010)
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
July 22, 2010 at 8:18 am
[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"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
July 21, 2010 at 10:52 pm
[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...
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
July 21, 2010 at 5:31 pm
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...
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
July 21, 2010 at 11:44 am
jeff.mason (7/21/2010)
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
July 21, 2010 at 11:38 am
WayneS (7/20/2010)
So,...
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
July 20, 2010 at 9:24 pm
Viewing 15 posts - 1 through 15 (of 79 total)