That is what carry Millsap's or Jonathan lewis fee. Just kidding. May be we get you some time for analysis. Regards, V
Hi joechang, You are right. Set statistics for several sql statements revealed that execution time 0 ms where compile time most of the time <non...
Hi Joechang, Thanks for your analysis. Older hardware is: 2 CPU single cores hyper threaded, Intel Xeon 2.8G, 4GB RAM, L2: 512K Newer hardware is:...
From MohammaeU Did you reindexed all tables OR update statistic with FULL SCAN after restore/migrate databases from 2000 to 2005?...
My case is few stored procs more dynamic sql (Non sharable plans). I guess we may have to conclude that, Compilation is more expensive in 2005 so...
Thanks Joechang, We had monitored those counter already. There are very few re-compilations. any time 20% of batch requests/sec ~= compilations /sec....
Hi MohammadU, Thanks for the information. We tested same application on both sql server 2000 and 2005 without making any changes but 100% CPU around...
Friends,[?] We load tested one of our application on SQL server 2000 SP4 vs. SQL Server 2005 SP2. (both on same System with 2 CPU hyper threaded, 4...
Hi, Question is little confusing. Do you think you can re-write the question again. Do you mean as below ? "As connections and activity on our...
I believe you are talking about query performance. I would start with profiler and trace the queries those taking longer than acceptable time. Check...
Thanks Mohammedu, Rightnow I am have huge waits (550 users load test) @RESOURCE_SEMAPHORE so I need to turn AWE ON. Thanks for directing me the hot...
Friends, Answer to my first question was found on microsoft site. (still need answers to my 2nd and 3rd questions)....
Friends,<br />We are in the process of benchmarking one of our applications on SQL server Enterprise version 32 bit ,2000 SP4/SQL server 2005 SP2.<br...
Separate names with a comma.
