Jump to content

jinnantonnixx

Members
  • Posts

    3,659
  • Joined

  • Last visited

Everything posted by jinnantonnixx

  1. I found this which might be of interest. Commentary: The Bitcoin Bubble and a Bad Hypothesis | The National Interest
  2. I've moved from Gnome3 back to stock Unity. There were a few annoyances with dual screens in Gnome3. I subscribed to oibaf's PPA for video drivers and everything is rosy. Unity has had some stick, but I find it superb for home and work use. It just works with no fuss.
  3. This canned answer is pretty close, but transfers the wrong way. It should give you a good handle on the problem though. rsync from linux to smb device (ie: mybook, windows computer, etc..) | Linux.org As an aside, I use Ubuntu as well, and use the .gvfs filesystem for my rsync, but that's in interactive, graphical mode, which probably isn't much use on your server. It's handy to know, though. ls ~/.gvfs/
  4. Good advice. I'd also add use a full face shield and ear defenders.
  5. Veering wildly on topic, I'm using a maintenance plan to reoganise indexes on the SIMS databases. I've checked the index fragmentation stats after the overnight job ran, and it appears to be effective. The maintenance plan wizard will guide you through it. I'm also looking at a maintenance plan to update statistics. If you rebuild your indexes, you only need to update column stats. If you reorganise your indexes, you can choose to update stats on indexes and columns.
  6. No LOLs - this is a serious thread. Is your antivirus tuned to not examine reads on your data/log drives or files? This is Symantec, but the principles are the same. http://www.symantec.com/business/support/index?page=content&id=TECH176828
  7. Simply marketing. The business model is for maximum revenue, and they can charge a premium price for a premium service. It's possible to move to a lower tariff if you ask, but the savings are small.
  8. Have you tried the memory checking scripts (mentioned in an earlier link) -- SQL Server 2008 and R2 Memory Related Queries -- Glenn Berry -- October 2010 -- http://glennberrysqlperformance.spaces.live.com/ -- Twitter: GlennAlanBerry -- Instance Level queries -- Good basic information about memory amounts and state (SQL 2008 and 2008 R2) SELECT total_physical_memory_kb, available_physical_memory_kb, total_page_file_kb, available_page_file_kb, system_memory_state_desc FROM sys.dm_os_sys_memory; -- You want to see "Available physical memory is high" -- SQL Server Process Address space info (SQL 2008 and 2008 R2) --(shows whether locked pages is enabled, among other things) SELECT physical_memory_in_use_kb,locked_page_allocations_kb, page_fault_count, memory_utilization_percentage, available_commit_limit_kb, process_physical_memory_low, process_virtual_memory_low FROM sys.dm_os_process_memory; -- You want to see 0 for process_physical_memory_low -- You want to see 0 for process_virtual_memory_low http://technet.microsoft.com/en-us/library/bb510493.aspx
  9. Good point @3s-gtech, if SQL is allowed to balloon it can result in a sluggish OS. http://www.edugeek.net/forums/mis-systems/112841-speeding-up-sims.html#post965532
  10. Yes, I've been with AutoAid for a few years. In my experience they are excellent, as long as you understand that you have to pay upfront then get reimbursed. Don't think you have to carry cash, either! I paid my breakdown invoice over the phone the next day with my credit card, then sent the invoice off to Autoaid for reimbursement. Simple. It worked out very well for me, as the policy covers multiple vehicles and covers spouse's,vehicles too. At one point I had my car, wife's car and a camper van covered for £36/year. The camper broke down in Barnstaple. I had a courtesy car from the towing company for the evening (it was too late for the driver's hours), the van was flat-bedded back to South Wales the next morning. The tow back cost just shy of £400, reimbursed within a week by AutoAid, even before it showed up on the credit card statement. I'm sticking with them, they suit me.
  11. Caching of what? The data is considered volatile and re-read with every move. You can show this with Profiler and Wireshark. For example, the pupil browser will run the sta_pix_EditStudentInformation_getstudent ...etc.... stored procedure every single time, even if you repeatedly flip-flop between two pupils. A quick experiment shows no caching is used. Wireshark shows the text (in clear text) coming from the server every time over the network. Perhaps I've misunderstood what you mean. I have to admit they've normalised the data quite a bit since I last cared to look at it. In your example, updating a phone record writes to the sims_telephone table only. This is a simple table linked by person_id - well normalised in anyone's book. A while ago, if memory serves (and I might be quite wrong), there were several telephone fields within the person record, but this has changed. I dare say someone could find horrors, but I think they are improving the underlying structure.
  12. Nonsense! It was Minnesota. Joking aside, I for one found RoF's posts very amusing. They always made me smile.
  13. This looks wheely cool.... Smart Wheel By FlyKly Could Change Everything About Commuting
  14. I'm trying to get around performance problems, and on my travels I discovered this; it won't help but I enjoyed the article. (I know education discounts are large) Are Commercial Databases Worth It? | Coding the Wheel Which brings me on to my next question, which I shall phrase rhetorically. Most (or many) of us are running enterprise-grade OSes, enterprise-grade SQL servers on enterprise-grade kit. This stuff is supposed to be able to cope with millions and millions of transactions. So why does pupil data for schools cause problems?
  15. Four times, Vik. Four times. My rate has gone up. I'm snowed under today, but this thread covers a lot of topics, including Activity Monitor. http://www.edugeek.net/forums/mis-systems/112841-speeding-up-sims.html
  16. Well spotted, Vik - schoolboy error. As you say, it changes the recovery model to 'simple', and leaves it there for your transaction log backups to fail. Nice feature of a reindex patch.
  17. Is it just the pedal? You can get a new set of bike pedals for under a tenner. (Watch the thread sizes, there are two common sizes).
  18. Tongue in cheek, but... Wirth's law is a computing adage made popular by Niklaus Wirth in 1995. It states that "software is getting slower more rapidly than hardware becomes faster." and May's law, named after David May, is a variant where: "Software efficiency halves every 18 months, compensating Moore's Law."
  19. You'll see NXDOMAIN messages when in debug mode and not using FQDN. This is because NSLOOKUP pastes in your DNS suffix(es) to try and make a FQDN that resolves to something. Can you compare the "DNS suffix search order" of a machine that works against a problem machine? "ipconfig /all" will show you.
  20. Also check your DNS suffix Run NSLOOKUP (press return) You're in interactive mode now. Type: set debug and now enter some names to be resolved. There'll be a whole screen full of stuff, I've often found that DNS suffix goes wrong, where it's not appending it to your domain names. Also try typing the FQDN of the server
  21. I'm going to guess that one of those addresses is not reachable from the clients. Delete the unreachable entry from DNS and see what happens.
  22. Slow reports by some chance? It's probably worthwhile scripting a reindex of your SIMS database(s). But first, you should know the current state. This script will show how the state of your index fragmentation. I've ignored indexes where the fragmentation is less that 25% and the page count is under 10 (these pages are likely to be cached in memory) then ordered by the page size in descending order. If you find a highly fragmented index with a lot of pages >100s then it's probably worth reindexing. Usual disclaimers, at your own risk, etc, if you don't know about queries, do not proceed. use [NameOfYourSIMSDatabase] SELECT OBJECT_NAME(OBJECT_ID), index_id,index_type_desc,index_level, avg_fragmentation_in_percent,avg_page_space_used_in_percent,page_count FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL , 'SAMPLED') where avg_fragmentation_in_percent > 25 and page_count > 10 ORDER BY page_count DESC Capita supply a patch to reindex (14265), but it's bananas as it changes the recovery model to 'Full' (bye bye differential backups/log shipping backups - you didn;t need them, did you?) and shrinks your log file to minimum (hello autogrow, hello log file fragmentation).
  23. I've got a heap of negatives and slides which I'd like to digitise. I have an ancient Minolta scanner, but it's so painfully slow I simply cannot bring myself to use it. Ideally, I'd like a standalone system, so I can lend to my parents, for instance, and one which scans at a reasonable speed to a memory card or USB storage device. Anyone know of something that'll fit the bill? Money is most certainly an object. Thanks.
  24. £59 with free delivery from John Lewis. Buy WD Live Media Player online at John Lewis I'm a big fan of Humax stuff, it's always been top notch. I have an old Foxsat recorder, years old but still runs reliably, cool and quiet. This looks good (1TB recorder, grade 'A' reburbished) with Freetime and a raft on on-demand stuff: http://www.humaxdirect.co.uk/product.asp?ProdRef=10209
×
×
  • Create New...