Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Perfomance @High end server

Author  Topic 

sunder
Starting Member

1 Post

Posted - 2008-06-27 : 06:42:36
I have a peculiar issue with my application when hitting the high end SQL server. SQL server takes 4 to 5 times more for a high end server where as the same task takes 5 times lesser in low end server. For example at high end SQL server a particular stored procedure takes 40 min to process certain number of records where as low end SQL server it takes hard to 10 min. to process the same amount of records.

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2008-06-27 : 08:42:57
You'd need to show us some "execution plans" before we can analyse this.
Also what do you call high-end/low-end?
Go to Top of Page
   

- Advertisement -