Viewing 15 posts - 11,416 through 11,430 (of 49,552 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),...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 5, 2013 at 6:14 am
isuckatsql (10/4/2013)
This is a discussion forum, so we discuss things, if you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 5, 2013 at 5:43 am
Put the values that your client wants to see, it's not my report.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 4, 2013 at 1:50 pm
OLTP does not automatically result in low PLE.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 4, 2013 at 1:03 pm
Viewing 15 posts - 11,416 through 11,430 (of 49,552 total)