Fred,

blocking locks mean that the blocking process id has some operation pending like an update or transaction that is preventing the blocked process ids from finishing their operation. if you select the blocking process id and selecct properties you can see the last command that process has executed.

I finally got to ask our DBA manager and she said they don't put a SQL server online now without at least 2gb ram and 2 cpus. She said also make sure the server is only running SQL, not being a file server or print server or IIS server etc.

>I went to the Clients Place after a long time & I noticed on the EM that there is sometimes Bloking and blocked SP IDs in the process info. And I noticed that a few tables have been locked. I checked the SQL it was just a Select statement. Why does SQL Server lock files when doing a query ? I then ran that same select from sql query analyser & ran the index tuning wizard it did not suggest any more indices. Why Am I getting blocking ? can You please help me. I appreciate your help so far and hope I am not being PITA.