Viewing 15 posts - 11,416 through 11,430 (of 49,562 total)
isuckatsql (10/5/2013)
Have you heard the term "pay it forward" ?
Do enlighten me, what should I be doing to 'pay it forward'?
I offered you advice on the count (as did Luis),...
October 5, 2013 at 8:44 am
T.Ashish (10/5/2013)
Luis, I disagree on not using NOLOCK. Even my project uses it in all reporting queries, and removing NOLOCK will result in tons of calls and mails at helpdesk.
Do...
October 5, 2013 at 7:17 am
Target is what SQL wants, total is what it has. Target>Total usually means SQL is increasing its memory allocations.
October 5, 2013 at 6:14 am
isuckatsql (10/4/2013)
This is a discussion forum, so we discuss things, if you...
October 5, 2013 at 5:43 am
Put the values that your client wants to see, it's not my report.
October 5, 2013 at 5:40 am
Run
EXEC sp_configure 'show advanced options', 1;
go
EXEC sp_configure 'allow updates', 0
GO
RECONFIGURE
GO
October 4, 2013 at 5:26 pm
Grant Fritchey (10/4/2013)
Others that would have been insanely high except weekend data processing would flush the cache completely.
That matches what I've seen in a lot of places. High and...
October 4, 2013 at 3:25 pm
If you're under so much memory pressure that pages read in 3 seconds ago are getting discarded, that server's going to be dead in the water no matter what kind...
October 4, 2013 at 3:11 pm
Dird (10/4/2013)
If you inserted 5000 rows into 100 pages per second then they wouldn't be discarded right away on account of the LRU algorithm?
Why would a page that's just been...
October 4, 2013 at 2:49 pm
I mean the normal dictionary definition of the word.
An OLTP system does not automatically have low PLE from being a OLTP system.
October 4, 2013 at 1:53 pm
isuckatsql (10/4/2013)
The more i used normalization, the slower the query performed, so it has gradually been denormalized, to improve performance.
Oh dear, that's really not going to help overall performance...
October 4, 2013 at 1:50 pm
OLTP does not automatically result in low PLE.
October 4, 2013 at 1:47 pm
isuckatsql (10/4/2013)
In testing the sub queries proved faster than Joins, as did the MAXDOP and NOLOCK.
So you don't mind if your results are inaccurate. Have you confirmed with the users...
October 4, 2013 at 1:19 pm
Dird (10/4/2013)
GilaMonster (10/4/2013)
IgorMi (10/4/2013)
PLE min values should not go under 300 seconds.
That was a poor recommendation 8 odd years ago when servers had maybe 4GB of memory. These days...
October 4, 2013 at 1:04 pm
Sean Lange (10/4/2013)
You have tons of correlated subqueries. These would be better as joins instead.
Not necessarily.
October 4, 2013 at 1:03 pm
Viewing 15 posts - 11,416 through 11,430 (of 49,562 total)