SQLTeam.com | Weblogs | Forums

Count query execution in two SQL version 2014 Vs 2017

Hi, a simple count() query to get the record count was executed in two different SQL server version. In 2014, it return ed result within seconds. Where as on SQL 2017, it took more time. Any guess regarding why a select count() from table name take different execution time? thanks

can you provide more details about the servers?
disk, ram, remote, local, same table, back up being done on both databases,
size of tables.

as you have it your question is very vague.

Please look at the execution plan ..

There could be several reasons .. You will have to narrow it down

Resolved by upgrading the server ram and other configuration