Jump to content

jinnantonnixx

Members
  • Posts

    3,659
  • Joined

  • Last visited

Everything posted by jinnantonnixx

  1. 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.
  2. 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/
  3. But for whose gain? This discussion is losing its sense of balance, and I'm not sure I like your tone.
  4. 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.
  5. I have conducted myself admirably, despite resistance from certain others who lack the capacity to remain grounded.
  6. Watt do you mean?
  7. For he will heel the masses in a great feet.
  8. This thread's been a bit quiet so I thought I'd touch bass with you all. This works on so many levels.
  9. 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.
  10. 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.
  11. 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/
  12. 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.
  13. Listen Honey, I'll get into anything I choose. By golly, I'll even get into marmalades.
  14. I'm glad you're working hard to preserve this thread.
  15. 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/
  16. 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
  17. Error messages, 1980s style. That's inexcusable these days.
  18. 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.
  19. Install qjackctl. This is a graphical control for Jack. From here you can choose the hardware from drop-down boxes.
  20. 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.
  21. Interview with the game's creator. The man who made 'the worst video game in history' - BBC News
  22. You shouldn't dish out praise like that.
  23. Why are there quotes around "Network"? Is it meant in an ironic way - is it not really a network?
×
×
  • Create New...