This query and many others take forever to run, this one in particular takes 10mins. We do not have any fragmentation on the underlying resources. I can't figure out why it takes so long. We also have 16 CPU - 64GB RAM and SW is the only DB running on this platform, we also have Netflow in a separate instance.
SELECT top 1000 DailyNodeAvailability.NodeID,
DailyNodeAvailability.DateTime,
DailyNodeAvailability.Availability
FROM DailyNodeAvailability