Jump to content

Jabali

Member
  • Posts

    11
  • Joined

  • Last visited

Reputation Activity

  1. Like
    Jabali reacted to leadeater in Small business Network Storage Solution   
    Anything from QNAP or Synology will do the job, personally I prefer QNAP.
  2. Like
    Jabali got a reaction from leadeater in Small business Network Storage Solution   
    Thanks LeadEater. 
    I checked out both and it looks like Synology has sales and service offices in India. So we will probably go for that.
  3. Like
    Jabali reacted to Alexokratis in SSD upgrade on Acer AN515-51   
    You will have to break the "Warranty Void if Removed" Sticker to open up the laptop to switch the SSD.
    Honestly, I would just do it myself. If you have a little experience in Hardware it will be no problem. Bringing it to Acer would be a waste of money (in my Opinion)
  4. Like
    Jabali reacted to leadeater in Server for MS SQL Server   
    I'm assuming you mean MS SQL and not a different SQL database engine like MySQL or Postgre?
     
    Just give it more space?
     
    MS SQL can use basically as many cores as you can throw at it, the limiting factor is data/table structure and query design. MS SQL is about as top class as you can get relational database engine wise.
     
    Other factors to look at is the server setting of Max Parallelism so a single query can't take/block all CPU cores and degrade other running query performance.
     
    What is the current specs of the server the database is on now? For a 50GB database you won't need 64GB of ram, unless it's some kind of special highly accessed database with odd access patterns 16GB will be fine and 32GB will be a lot.
     
    Also why so much storage when the database is so small? For the most part data comes out of ram so putting blistering fast storage behind MS SQL won't necessarily lead to higher performance than another lower class but fast storage.
  5. Like
    Jabali reacted to NelizMastr in Server for MS SQL Server   
    We have customers running SAP Business One environments with much larger SQL databases on servers with a single 6 or 8-core CPU, SAS 15K storage and 32-64GB of RAM without any performance issues whatsoever, so I agree with @leadeater here that there's really no point in throwing so much hardware at a rather small database. 
     
     
×