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