some experienced programmer in our company said they use SQL profiler to check the bottleneck of SQL loading on that SQL box to see:
1) is there any network content from SQL client to SQL server.
2) is there any SQL call loading from SQL client to SQL server.
3) Transaction per sec can go inside the SQL server.
how can SQL profile help on this?