Viewing 15 posts - 271 through 285 (of 1,790 total)
And how do you have memory configured? min server memory and max server memory? You don't really have much headroom on there so you really can't change too much.
Did...
March 1, 2011 at 7:31 am
You are definitely suffering from memory pressure. Hard to say beyond that with the information you provided though. 🙂
March 1, 2011 at 7:11 am
Oh, ok. Since you posted in a 2005 forum I assumed that you were on 2005.
No worries about the plans. Post them when you get them and we can...
February 28, 2011 at 9:32 am
A couple things. First, why do you have compatibility set at 80 for this database? I don't think that is the issue but.... Secondly, can you provide the table structure...
February 28, 2011 at 8:57 am
Do you not want a transaction NOT to be applied or is it causing errors? If it is causing errors then you can allow it to be skipped by changing...
February 28, 2011 at 8:31 am
Well, this can certainly be a problem and it is typically caused by improper indexing even though things may appear correct. It may also be due to a complex query...
February 28, 2011 at 8:13 am
As for the "no current full backup" problem, check the SQL Server log before the transaction log backup that ended in that error and see if the database switched recovery...
February 28, 2011 at 6:45 am
I hadn't heard back from you on this but thought I would provide this to get you started. This will generate the script that you would need to do that...
February 25, 2011 at 4:03 pm
CirquedeSQLeil (2/25/2011)
SQLkiwi (2/24/2011)
David Benoit (2/24/2011)
I remember when I took my first programming class, Pascal (Turbo actually)...I did a term using Turbo Pascal at University too.
Hmm - high school for me
Not...
February 25, 2011 at 3:31 pm
In a simple sense, yes, which is why setting max server memory appropriately is necessary. It would be good to read through the links posted in the link that I...
February 25, 2011 at 3:21 pm
Not sure. 🙂 The first comment is enough to point people to the other post though.
February 25, 2011 at 3:00 pm
What you are describing is correct behavior. So you want to ensure that max server memory is set low enough so that other processes have enough memory for what they...
February 25, 2011 at 2:59 pm
Duplicate post. Please post all replies to http://www.sqlservercentral.com/Forums/Topic1069880-391-1.aspx
February 25, 2011 at 2:56 pm
simone.alessandri (2/25/2011)
February 25, 2011 at 2:22 pm
GSquared (2/25/2011)
I say things like, "we'll burn that bridge when we come to it".
Ummm, I say that exact thing to my children all the time. 😛
February 25, 2011 at 1:59 pm
Viewing 15 posts - 271 through 285 (of 1,790 total)