Our application/queries run much faster in testing enviroment with the same number of users.

About memory,

Thanks Oliii for pointing out perf counters for memory.

We do have a monitor...

Thanks, sqlbuddy.

This is very helpful, I will bookmark it for future reference.

Thanks so much. Please see in lines.

1. Even if you add additional memory, it is necessary to configure the above settings to get optimum Performance. If it is dedicated SQL...

I can be flexible as long as OS is fine with that.

I see the targeting memory is already 9.2, so if I set max to 8.5, is that OK?

Thank you, it is enterprise 64 bits.

Thank you both, I will look into this and give it a try tomorrow.

A couple of thing I don't quite understand is 1. Warren said " If I were you...

Also can I setup a performance monitor to trace what could cause the bottle neck or blocking?

If so, what events shall i choose?

Thanks

Thank you, so I guess the second query I can get what query could cause the block, thanks.

Could you please explain a little what the two queries do,

One is sqlzealot-81 query.

The other is

Select st.text,sp.* from sys.sysprocesses sp

cross apply sys.dm_exec_sql_text(sp.sql_handle) st

order by sp.cpu desc

Do I...

I know I can use sp_who2 and sp_who to find which ProcessID is blocking another.

Is there a way that I can find which query or stored Procedure is caused blocking?...

I cannot find eventID 7035. Also MSSQLserver related event users are all n/a

So I go to Security tab of windows log and checked records happen in that time

I found messages...

Thanks, but I'm not asking the system or the server, I'm asking sql server services, do those messages in sql server log mean the sql server service is restarted?

Thanks

Is it also related with using system stored procedures ?

Thanks, here I really mean sql developers not dba,

I'm interesting to be a sql developers too, so just curious what is the work flow and how web developers work...

I see the report of schema change history, I see our report is huge, I export to excel to do some filtering.

If MS can add some filter on the report...