|
We are getting hammered by the Witango server. In a recent
trace of over 350,000 rows from a 5 minute trace, more than half the requests
included the following text sent from Witango server. This is causing the db to be overloaded and the app server
daemons to hang. Below is a list of the textdata sent to the sql server: ----------------------------------------------------------------------------------- exec sp_tables NULL, N'%', NULL, N'''TABLE''' ----------------------------------------------------------------------------------- -- sp_tables if @table_qualifier = '' and @table_owner = '%' and @table_name = '' ----------------------------------------------------------------------------------- -- sp_tables if @table_qualifier is not null ----------------------------------------------------------------------------------- -- sp_tables select @type1 = '' ----------------------------------------------------------------------------------- -- sp_tables if (charindex('''SYSTEM TABLE''',@table_type) <> 0) ----------------------------------------------------------------------------------- -- sp_tables select @table_name = '%' ----------------------------------------------------------------------------------- -- sp_tables if @table_owner is null /* If no owner supplied, force
wildcard */ ----------------------------------------------------------------------------------- -- sp_tables select @type1 = @type1 + 'U' /* Add User Tables */ Help. p. ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf |
