I do agree they should explain the rational behind some of these fundamental configuration changes.
Your email got me curious so I looked up and found these articles. Parameterization http://technet.microsoft.com/en-us/library/ms175037(v=sql.105).aspx I recall Read Committed Snapshot and Snapshot Isolation reduces possibilities of deadlocks. http://msdn.microsoft.com/en-us/library/tcbchxcb(v=vs.80).aspx Joe _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of John Sundberg Sent: Wednesday, June 05, 2013 11:23 PM To: [email protected] Subject: Re: For MS SQL Database: "MS SQL Recommendations for BMC Remedy" ** I took a quick look at the doc. I see that a few settings should be made -- however, my first question is -- why should they be made? The doc says how to set them - but really - why they should be set - would probably be helpful. Thanks, -John On Wed, Jun 5, 2013 at 7:42 PM, Munukutla,Ravishankar <[email protected]> wrote: ** Please check this. For MS SQL Database: "MS SQL Recommendations for BMC Remedy" https://communities.bmc.com/docs/DOC-23931 Regards, Ravi Munukutla Ravi Shankar Sr Mgr - Product Development REMEDY - AR SYSTEM R&D BMC Software, www.bmc.com <http://www.bmc.com/> Phone: 91-20-39875273 Mobile: 91-9850964564 <http://www.bmc.com/bsm> Learn more about Business Service Management <http://www.bmc.com/> BMC Software _ARSlist: "Where the Answers Are" and have been for 20 years_ -- John Sundberg Kinetic Data, Inc. "Your Business. Your Process." 651-556-0930 I [email protected] <http://www.kineticdata.com/> www.kineticdata.com I <http://community.kineticdata.com/> community.kineticdata.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
