Server 2012 and SqlBase 12

Discussion forum about all things SqlBase.
peterhalton
Great Britain
Posts: 7
Joined: 05 Mar 2019, 16:37
Location: Edinburgh UK

Server 2012 and SqlBase 12

Post by peterhalton » 06 Jun 2019, 14:45

I just moved SQLBase 12.0.2 from Win 10 to Server 2012 R2 and now performance is terrible.
Any suggestions?

Steve Leighton
Site Admin
Site Admin
New Zealand
Posts: 65
Joined: 05 Mar 2017, 20:57
Location: Tauranga, New Zealand

Re: Server 2012 and SqlBase 12

Post by Steve Leighton » 07 Jun 2019, 02:51

Possibly stating the obvious here, but :
Network traffic / bandwidth ? recent Unload/Reload ? Isolation Level ? Antivirus ? Update statistics ?

We currently run a 30Gb SQLBase 12.1.1 on Server 2012 R2, with 150 active users, on RC3 isolation, and its performance is great when the Network bandwidth is not hogged by other processes , but it is a big SSD server.
One improvement often overlooked is 'sortcache' on the server sql.ini . Get it down to 1000 or max 2000. as even 1000 allocates 1Mb for every single 'Order By' performed, so anything higher could be a bottleneck.
Generally when performance is a problem after moving to another machine - the issue is network related in my experience.
Best wishes
Steve
Bankside Systems Ltd. ( UK ♦ Australia ♦ New Zealand )
www.banksidesystems.co.uk

FRBhote
India
Posts: 1326
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: Server 2012 and SqlBase 12

Post by FRBhote » 07 Jun 2019, 04:56

Is your server set to Best performance for Background Services?

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 0 guests