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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-31 : 09:02:27
|
| Justin writes "A web application is pounding a sql server 2000 server with SET NO_BROWSETABLE commands. We are trying understand the purpose of the command and it's potential impact on server performance. An extensive search of BOL, TechNet, MSDN, and other SQL Server web sites and books has resulted in only a single seemingly relevant article: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndive/html/data11082001.asp . It provides some insight but does not answer the performance impact question or why the developers are (knowingly or unknowingly) issuing this command. Any help would be appreciated.OS: Windows Server 2003DBMS: SQL Server 2000, sp3" |
|
|
TimS
Posting Yak Master
198 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-31 : 10:13:18
|
| Sounds like the application is trying to get Schema data to decide how its going to construct queries.If its asking for schema stuff before every query the amount of "traffic" on schema stuff probably outweighs any "real" traffic ...Kristen |
 |
|
|
|
|
|
SET NO_BROWSETABLE ON