About
Praveen Chamarthi works as Manager, Operations Support
You will find most of his writings related to Photography, Travel and a bit of Programming (New found love – jQuery).
BIO
Has 12yrs of hands on experience as a Designer, Developer, Problem-Solver. Has worked in all leading platforms UNIX, JAVA, MICROSOFT, LINUX etc.
He loves to travel and he wishes to tour around the world backpacking.
Check out his blog here
More on his Flickr Photo Stream.
Hi Praveen,
I just discoverred your great blog today, and will check your photos soon. We are a french based editorial (online magazine) and services (web hosting) website for photography and i do have a problem with my mssql database, left unsolved for weeks, so thought may be i should ask you if you ever faced that kind of issue.
The number of locks increases all the time although :
- i can’t see/trigger any ASP error in my code
- the is NO lock escalation (as trace profile reports)
- no deadlock chain either
- the number of locks drop to zero when i restart mssql service but then starts again to grow instantly, reaching thousands after several days
- enterprise manager logs do not report anything special
Every single client of us (photographers websites) gets blank pages with a message related to impossibility to connect to the db, or on some pages it’s just one ore more images that won’t display (i use a SP to display images to avoid hotlinking and other similar issues)
If you have a clue, please let me know, it will be much appreciated !
Regards.
2nd max sal without whereand max clause
What is the Difference Between Primary Key and Primary Key Constraint