My database is creating when i retrive value in datagrid it will take time to retrive. also i got message from discountasp.net the message is : It has come to our attention that your database SQL2005_34985_absiras0706 is causing an excessive resource usage problem (CPU, DISK I/O), which is negatively affecting other customer databases hosted on the same SQL server. Please take steps to optimize your database queries or the database itself via proper indexing, defragmentation, etc. to increase performance and lessen the impact on the SQL server. Unfortunately, DiscountASP.NET support cannot provide any assistance with specific database queries or optimization. Please let me know any suggestion?
What type of queries are you running against the SQL Server. What is the statement line DASP determined was a major culprit of the SQL CPU resources. Do you have adequate indexes against your database? junior DiscountASP.NET www.DiscountASP.NET
