Server 2012 and SqlBase 12

Discussion forum about all things SqlBase.
peterhalton
Great Britain
Posts: 46
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?

User avatar
Steve Leighton
Site Admin
Site Admin
New Zealand
Posts: 274
Joined: 05 Mar 2017, 20:57
Location: Tauranga, New Zealand <--> Stroud, England

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.
Greetings from New Zealand
Steve Leighton

Bankside Systems Ltd.
UK ♦ Australia ♦ New Zealand

www.banksidesystems.co.uk

Image

FRBhote
India
Posts: 2172
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: [Ccbot] and 0 guests