0

I am very puzzled with the problem I am going to let you know.

I have taken shared hosting. But server administration is saying our sites are giving too much load on the server from temp files it is creating.

What could be the reason.... and how to free load from server.

Please Help Me It's urgent.

Improve this question
1
  • Did you only installed an SqlServer or maybe some other software too? Maybe it's not the SQL Server. How do you know?
    – BitKFu
    Sep 2, 2010 at 5:21

1 Answer 1

Reset to default
2

I would say that you need to index your tables. It could be that your SQL queries are doing expensive table scans. Can you show us what one of your SQL queries looks like and then provide a schema definition for that table it operates on? that way people here on Serverfault can correctly diagnose if there is some kind of indexing issue.

Improve this answer

You must log in to answer this question.