September 7, 2022 at 3:19 pm
I have a saying that I borrowed from the Submarine Service about things like that... "Don't worry about the fire... the flooding will put it out". π
Same as the English saying "Take care of the pennies and the pounds will take care of themselves", "take care of the deadlocks and the transactions will take care of themselves"
π
Still think of deadlocks as an ailment, no healthy measures will ever apply.
September 7, 2022 at 3:19 pm
I have a saying that I borrowed from the Submarine Service about things like that... "Don't worry about the fire... the flooding will put it out". π
Same as the English saying "Take care of the pennies and the pounds will take care of themselves", "take care of the deadlocks and the transactions will take care of themselves"
π
Still think of deadlocks as an ailment, no healthy measures will ever apply.
September 7, 2022 at 3:25 pm
Jeff Moden wrote:I have a saying that I borrowed from the Submarine Service about things like that... "Don't worry about the fire... the flooding will put it out". π
Same as the English saying "Take care of the pennies and the pounds will take care of themselves", "take care of the deadlocks and the transactions will take care of themselves"
π
Still think of deadlocks as an ailment, no healthy measures will ever apply.
Right there with you brother.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 7, 2022 at 5:05 pm
Eirikur Eiriksson wrote:Jeff Moden wrote:I have a saying that I borrowed from the Submarine Service about things like that... "Don't worry about the fire... the flooding will put it out". π
Same as the English saying "Take care of the pennies and the pounds will take care of themselves", "take care of the deadlocks and the transactions will take care of themselves"
π
Still think of deadlocks as an ailment, no healthy measures will ever apply.
Right there with you brother.
The interesting thing is that in the current environment, we are facing millions of transactions per second, which makes one ponder on transactional latency!!
π
Only a handful of years ago, I was very proud of 30-50K transactions per second on my systems.
We are now not in the space of milliseconds, only takes a few micro seconds to clog the system.
September 7, 2022 at 5:38 pm
I had a SQL Server 2000 system that got to 25k transactions/sec when we turned on the intranet. The intranet was too slow that day, and I told them that was all we had, or as Scotty would say, She's giving you all she's got". Since we had about 10,000 people in the company and they were running dozens of queries to populate and update things on the home page, set to the default for everyone by group policy, wasn't much I could do.
I was actually proud my database did so well.
September 8, 2022 at 12:47 pm
I had a SQL Server 2000 system that got to 25k transactions/sec when we turned on the intranet. The intranet was too slow that day, and I told them that was all we had, or as Scotty would say, She's giving you all she's got". Since we had about 10,000 people in the company and they were running dozens of queries to populate and update things on the home page, set to the default for everyone by group policy, wasn't much I could do.
I was actually proud my database did so well.
This brings back memories....
π
Back in the days of SQL Server 7.0, I had a cluster (Wolfpack) as a back end for my web hosting service, every website launch made the cluster rattle. We had a request cache to reduce the load on the databases and often saw 15-20K t/s whilst the cache was initially populated. Ended up writing a pre-load service that scraped the websites for any links or possible users' interactions that would enter or alter the content of the cache. After enabling the pre-load service, we hardly saw any spikes on the databases.
September 8, 2022 at 1:53 pm
I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me know the version you ran it on and post the results?Β Thanks for the help, folks.
SELECT A = 2147483647/1000
,B = 2147483648/1000
;
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution π
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 8, 2022 at 3:15 pm
This was removed by the editor as SPAM
September 8, 2022 at 5:56 pm
Jeff Moden wrote:I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me know the version you ran it on and post the results?Β Thanks for the help, folks.
SELECT A = 2147483647/1000
,B = 2147483648/1000
;
That pretty much cinches it.Β Thanks, Johan.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2022 at 6:28 pm
Whatβs happening with ASK SSC at the moment, I keep reporting a lot of spam topics but no one is removing them.
Is that site dead now or is Redgate phasing it out as I see itβs link here in the menu has also gone.
September 9, 2022 at 8:00 pm
Whatβs happening with ASK SSC at the moment, I keep reporting a lot of spam topics but no one is removing them.
Is that site dead now or is Redgate phasing it out as I see itβs link here in the menu has also gone.
While the link in the menu might be gone, there's still a large "icon" in the lower right of the page if you scroll down to it.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 14, 2022 at 7:31 pm
Removed what's probably an inappropriate rant based on extreme frustration.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 13, 2022 at 3:00 pm
Dataminds Belgium 10/11 oktober was great
October 13, 2022 at 3:27 pm
Dataminds Belgium 10/11 oktober was great
100% agreement
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 13, 2022 at 3:48 pm
Sorry I missed it. I loved the event in 2021. Was in Boston last weekend and heading to NY today, so no time to come over and remain married.
Viewing 15 posts - 66,046 through 66,060 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply