-
Posts
3,659 -
Joined
-
Last visited
Content Type
Forums
News
20th
EduGeek EDIT Conference
Blogs
Everything posted by jinnantonnixx
-
Better late than never.... The history of pi The history of why pi equals 3.14(15926?) - Quartz and a picture of a pi pie.
-
[pics] ...then you will see a fork in the road...
jinnantonnixx replied to 6Foot2's topic in Jokes/Interweb Things
-
Here's the thread where @arron discovered the problem and the solution http://www.edugeek.net/forums/mis-systems/147490-sims-slow-after-upgrade-sql-2014-a.html << should be a sticky, mods! A month later Capita discovered the problem and the solution. https://myaccount.capita-cs.co.uk/hot-topics/sims-sql-2014/
-
Weird Non-IT Request of the Day #1 - Identify Signature....
jinnantonnixx replied to tech_guy's topic in General Chat
My guess is G or O Scheidegger -
But for whose gain? This discussion is losing its sense of balance, and I'm not sure I like your tone.
-
How are your processors configured? If they're configured as sockets rather than cores, SQL Standard Edition will only use four sockets, idling the other sockets. A real gotcha. https://www.brentozar.com/archive/2014/11/core-based-licensing-matters-performance-tuning/ https://msdn.microsoft.com/en-us/library/ms143760%28v=sql.120%29.aspx In any case, there are so many variables with 'poor performance' it's difficult to know where to even begin. Activity Monitor is as good a place as any. http://www.sqlservercurry.com/2013/04/activity-monitor-in-sql-server.html Watch the graphs for a while, see if anything looks a little off.
-
I have conducted myself admirably, despite resistance from certain others who lack the capacity to remain grounded.
-
Watt do you mean?
-
For he will heel the masses in a great feet.
-
This thread's been a bit quiet so I thought I'd touch bass with you all. This works on so many levels.
-
I caught up with The Big Short and Bridge of Spies at the cinema this week (they had a week of Oscar re-runs) Thoroughly enjoyed them both. The Big Short had some delightful black humour and was very engaging. Bridge of Spies was excellent, but one or two scenes were just a big too Spielbergy for my taste.
-
The first thing I'd do is write a debug line to console with the value of a variable that has retrieved Request.Form["FirstName"] See if it contains anything.
-
[sims] Sims Server Performance Benchmarks - 2016 Edition
jinnantonnixx replied to Sam_Brown's topic in MIS Systems
Here's a thought - maybe the reports make heavy use of the tempdb file(s). Every insert into the tempdb needs a log update, so this could be the bottleneck, especially if the tempdb log file is on the same disk as the database files. Could be an I/O problem. Perhaps if you move the tempdb to a different disk/LUN, even though the tempdb data and log file share the same disk, at least it doesn't share the same disk as the SIMS database. Just a thought, and I might be completely wrong. We have several tempdb files (using the one per-processor rule-of-thumb) on a separate LUN, and keep the SIMS database and log files on separate LUNs, and the server OS on yet another disk. This minimises I/O contention. The Brent Ozar site is a treasure trove of SQL goodies. https://www.brentozar.com/sql/tempdb-performance-and-configuration/ -
[sims] Sims Server Performance Benchmarks - 2016 Edition
jinnantonnixx replied to Sam_Brown's topic in MIS Systems
A large log file won't cause (read/query) performance problems but it could be an indication that all is not well on the backup front. Managing Transaction Logs - SQLServerCentral And the log file growing in small intervals is precisely what you get when you shrink the log file to its minimum - The reindex patch does this, BTW. -
Listen Honey, I'll get into anything I choose. By golly, I'll even get into marmalades.
-
I'm glad you're working hard to preserve this thread.
-
[sims] Sims Server Performance Benchmarks - 2016 Edition
jinnantonnixx replied to Sam_Brown's topic in MIS Systems
How are you guys partitioning your systems? Ideally, you should have the OS, data drive, log drive and temp drive on their own LUNs or at least separate physical disks. If everything is stuck on a single drive, you're generating your own I/O bottleneck. https://www.brentozar.com/archive/2009/02/when-should-you-put-data-and-logs-on-the-same-drive/ -
[sims] Sims Server Performance Benchmarks - 2016 Edition
jinnantonnixx replied to Sam_Brown's topic in MIS Systems
Have you switched compatibility to 2012? There's a known problem with SIMS and native SQL 2014, discovered by aaron here: http://www.edugeek.net/forums/mis-systems/147490-sims-slow-after-upgrade-sql-2014-a.html -
Error messages, 1980s style. That's inexcusable these days.
-
If all that fails, try deleting the Jack config (don't worry, it will be recreated next time Jackd saves its settings) rm ~/.config/jack/conf.xml Then run the graphical qjackctl tool. Configure Jack to use the hardware it finds, then save the settings. To be fair, I hardly ever get into a tangle even with a couple of different USB sound cards, Jack, ALSA and PulseAudio running together.
-
Install qjackctl. This is a graphical control for Jack. From here you can choose the hardware from drop-down boxes.
-
Maybe the ALSA plugins are missing: Install libasound2-plugins either from the software centre/synaptic or from the terminal prompt: sudo apt-get install libasound2-plugins I use Jack all the time with MusE sequencer.
-
Interview with the game's creator. The man who made 'the worst video game in history' - BBC News
-
You shouldn't dish out praise like that.
-
Why are there quotes around "Network"? Is it meant in an ironic way - is it not really a network?
