Four very broad SQL Server questions… | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Four very broad SQL Server questions…

Hi all, have an meeting with management of another client, a nervous one famed for asking strange questions – so I was hoping to go in armed with some good artillery… 1) What are the most common causes of sqlserver.exe stopping suddenly (aside from Admin explicitly stopping)? – this one had me stumped – it’s never happened to me. 2) What are the best non-hardware methods to optimise performance on heavily and frequently updated tables? 3) What is the best way to troubleshoot poor apps performance with SQL Server? – I’m thinking Profiler trace of events/Perfmom counters, they’ll doubtless ask for the most common ones too… 4) How does SQL’s native Backup/Restore compare with 3rd party tools?
That’s all for now, I’ll post more questions as they come to mind. Thanks in advance,
Jaybee. France. The finest wines. The tastiest cuisine. The most delicious women.
Here’s my 2 cents (well, 3 cents i guess) for 2:
make sure you have the required indexes and ensure the statistics are up to date for 3:
examine the sql used in the app for 4:
in my limited experience 3rd party tools seem to be quicker and provide more options (encryption, compression)…i think whether they are better depends on the individual case- compression and encription are achievable to some extent using non-specialised tools (like winrar) Ben ‘I reject your reality and substitute my own’ – Adam Savage
Well, I can´t write a book about that, but some tips. 1) Hardware error, old services pack.
2) Maintenance plan, such as: Reindex, Update Statistics. Monitoring, with Performance Monitor and Profiler.
3) Profiler and tuning looking for good indexes. If you can change original code, then analize and re-write if neccesary.
4) It’s depends on severals questions: a) Using tape? b) Plenty space on disk? c) What kind of recovery model database has?, etc. And wait for others members oppinions.
Luis Martin
Moderator One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
SQL Server comes along with a complete and easy to search online help (BOL). In addition to BOL are there excellent online resources available for free that contain the answers to the broad questions you asked. It not that we aren’t willing to help, but it’s better to do the introductory research by yourself and then come back with more specific questions. —
Frank Kalis
Microsoft SQL Server MVP
Ich unterstütze PASS Deutschland e.V. for your information too which is a good resource. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi ,<br />1) even i am … without explicitly stoping it never stops to me tooo…if any of their team member have issue out of this command (may be other can ,i know this many) :<br /><b>SHUTDOWN [ WITH NOWAIT ] </b> <br /><b>net stop mssqlserver</b><br /><b>scm with 6 </b> <br /><br />2) <a href=’’ target=’_blank’ title=’'<a target="_blank" href=></a></a><br /><br />3) Absolutely profiler and a third party tool is Coeffiecient (my preference)<br /><br />4) depends upon media / method / tool<br /><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />Regards. <br /><br /><br /><br />hsGoswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami<br />
Hi Jaybee ,<br /><br />1) What are the most common causes of sqlserver.exe stopping suddenly (aside from Admin explicitly stopping)?<br /><br /><b> <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">- one more thing i forgot if MS SQL Server – service start with the Windows Administrator Account and if password of Windows Administrator is changed then it stops untill u won’t change the password in SERVICE/ MSSQLSERVER .<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"></b><br /><br /><br />[<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]<br />Regards.<br /><br />hsGoswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami<br />