Hi All,
Recently our application went for Load Testing and in the profiler trace of out DB we found out that the T-SQL emitted by the aspnet_regsql command ran for more than 341 times, whereas it must only for the creation of the Notification table and the SPs it uses for reading and writing values into this table. Does anyone have any idea why this happened?
I will elaborate the steps of deployment also as follows:
1) Code is deployed to App Server 2) Database is created on a differnet server along with tables and SPs etc 3) Database tables are enabled for Sql Chane Notifications by using the AspNet_RegSql.exe