Crash - PLEASE HELP!

[kevin plummer]

Here is a link so you can see what queries to run in SQL to find the locked spid if indeed it is SQL

https://www.mssqltips.com/sqlservertip/2429/how-to-identify-blocking-in-sql-server-2005-and-2008/

[ralonso2001]

Thank you Kevin.
I've made severar tweaks based on yours (and Bruce's) suggestions and it's been 24 hours without a hang!!!
I'm very happy!
I'll let you know how it continues.
Thank you very much (thanks to Bruce also!!!)

[broche]

Are you using SSL?

Brian

[ralonso2001]

Hi Brian. No Im not using SSL.
Could SSL improve the performance ? I know its better for security reasons.
Its a lot of work to make my site SSL?

Thank you!!

[Bruce]

Hi Rodrigo,

>> Could SSL improve the performance?

no. SSL makes performance a little bit worse. But it's not really noticable.

>> I know its better for security reasons.

YES. Basically if you are using non-SSL then you should consider all the data to be completely public. (Which is obviously ok for many sites.) But if you have a login and the site is not SSL then you should consider the login to be pretty easy to bypass.

>> Its a lot of work to make my site SSL?

no. It's very simple.
a) get certificate
b) tick "Use SSL" checkbox in app.

cheers
Bruce

[ralonso2001]

Thank you Bruce!