Problem in database

[sandeepniet]

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?

[junior]

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 (http://www.DiscountASP.NET)