搜索
.NetWebMail:feigmin@sina.com200549.net.NetBBS15202000PC……300500100HPPCSqlServer……2003………….NetWebSqlServer.Net12“”31web“”““TTFBTTLB2web1web(stresstesting)……23TTFB/TTLBWeb–––23.Net.Net.netSqlBmsBMSIOinsert,update,deleteSqlSELECT*FROMtbFileWHERE(cnvcType='110442')––––SETSTATISTICSIOon–SETSTATISTICSIOoffSelect*WhereisnullWhileisnotnullWhereid=@x/2id*2=@x……Sql1SELECT*FROMtbFileWHERE(cnvcType='110445')2SELECTcniidFROMtbFileWHERE(cnvcType='110445')Sql1230SqlSqlProfilerSqlSQLEXPERTSqlProfilerSqlProfiler.netMicrosoftApplicationCenterTest(ACT)OpenSTAWeb.NetADO.NETProviderSystem.Data.SqlClientSystem.Data.OracleClientSystem.Data.OleDbSystem.Data.OdbcProviderProviderMSDE/SQLSqlClientOracleOracleClientSQLNorthwinds50%=%htmlDataProviderADOADO.NETASP/ADOASP.NETw/System.Data.OleDbASP.NETw/System.Data.SqlClientDataProvider0100200300400500600700800900ASP/ADOOLEDBASP.NETSQLASP.NET/4P:SqlServer50Web:ClassicASP%%w/ADOASP.NET%%w/ADO.NETASP.NETRepeaterw/ADO.NETASP.NETDataGridw/ADO.NET0100200300400500600700800900ASPASP.NETDataGridASP.NETRepeaterEBASP.NET%=%/4PWebWebAPIAPI%@OutputCacheDuration=60VaryByParam=None%DurationHTTPVaryByParamnone*POSTVaryByControlLocationOutputCacheLocationSharedVaryByCustomVaryByHeaderApplicationSessionViewstateSystem.Web.Caching.Cache……Asp.netWeb.configcompilationdebug=“false”/VS.NETWeb.configIIS6.029––IIS6.060%800mb——51Testing