Forum Discussion
Need help SQL query performance issue
I am looking to help optimize the below select statement I have created supporting indexes and updated statistics , the same query is taking 2sec in one database ( note that same table structure an...
Lot of stuff to check and compare servers and Its not that easy to compare.
You need to deep dive into things like
-- Hard disk cluster size.
-- server size, O/S, memory, # of CPUs
-- allocated RAM to SQL Server, MaxDOP settings,
-- allocated TEMPDBs and their sizes
-- indexes and # of pages with data
-- statistics, execution plan