SQL Server Performance Forum – Threads Archive

Web Service on SQL Server 2005

Will Hosting Web services and Database on dedicated servers give better performance than Hosting web services using the HTTP endpoints on SQL Server 2005? The web services are going to be doing very little other than read/write to the database. The amount of data being processed can be said to be of medium load.

Hi,
its not recomended to keep IIS and SQL Server on the same machine,kindy search the forum this topic is discussed earlier. Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
————————
http://hemantgirisgoswami.blogspot.com

SQL 2005 has this capability and Microsoft provided the provision after such a requirement from previous versions and usage. I would suggest to review the database growth in next 3 years and prepare with relevant resources on hardware & software to avoid any issues in due course. Articles FYi,
http://www.developer.com/services/article.php/3390241
http://www.devx.com/dbzone/Article/28577 Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

Hi,
but their’s a chance of vunerability / slq injection if security is not implemented in proper way.
Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
————————
http://hemantgirisgoswami.blogspot.com

Thats a good point Hemant, refer tohttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/soapscenarios.asp article in this case that explains your doubts. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

Nice Link Dada, thanx.
Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
————————
http://hemantgirisgoswami.blogspot.com

Thanks guys for the reply. True that we have to consider the database growth for deciding this. It may be possible for me to get the growth pattern using previous data that we have, but has Microsoft published the criteria / pattern / scenarios where Hosting web services using the HTTP endpoints on SQL Server 2005 is more suitable vis-a-vis Hosting Web services and Database on dedicated servers ?

quote:Originally posted by satya SQL 2005 has this capability and Microsoft provided the provision after such a requirement from previous versions and usage. I would suggest to review the database growth in next 3 years and prepare with relevant resources on hardware & software to avoid any issues in due course. Articles FYi,
http://www.developer.com/services/article.php/3390241
http://www.devx.com/dbzone/Article/28577 Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

Refer to the Technet link I have referred above that highlights few bits and pieces of information you’re looking for, in general Web Services is a new concept in SQL 2005 and may search onhttp://www.microsoft.com/sql site for any case studies in this case, I will update the thread if I find anything similar. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

]]>