arooj300 (4/7/2014)
Thanks Keith for replying so quick.one more is question : I have sql server 2008R2(RTM) and two production database is running. And from one week client has complaining slowness issue. I have checked evrything like cpu usage, memory, profiler. everywhere its showing normal.
is there any possibility , the slowness issue is because sql server version.
do i need to upgrade the sql server 2008R2(RTM) to sp2 ?
How do you determine normal? Have you measured values to compare? Are you checking specific queries that are slow? Have to examined execution plans? Are they "normal" to something you compare them to? Is the client measuring from their application? Perhaps something else on another server or the client is running?
There's lots to check and as Gail mentioned, it's not likely this is version related.