How’s your SQL Server running? Backups taking too much space? How is Infor helping you with this? Your channel partner? Where can you get help?
Just a few tidbits I learned from some SQL MVPs:
** Be careful with this one…can bring down your SAN and SQL!
- Leave 4 gig (or 10%) of RAM free on SQL Server for O/S. RDP into server uses RAM that doesn’t get freed up until reboot. You can set your SQL RAM in Mgmt Studio, Database, Properties.
- Lots of stuff on waits, and latch waits. For example, the following script can help pinpoint performance problems.select * from sys.dm_os_wait_stats order by wait_type
- Free tools:
a. SQL Search by Redgate
b. SQL Decryptor
c. SQL Sentry Plan Explorer
f. Notepad ++
g. SQL Compare
i. SSMS Toolspak (snippet)
j. Ola.hallengren.com (maint scripts, rebuild indexes)
k. Performance Analysis of Logs (PAL) Tool
- Absolutely no reason not to compress your SQL backups!
From Tim Ford –http://thesqlagentman.com/go/presentations
Hopefully, some of this information will help you next time someone screams “Visual is SLOW!!”
Peter Boers is our special guest author at visualnuggets.com and is an active participant in the VISUAL community. Peter has recently taken on the responsibility for maintaining the web site for the newly formed Visual Enterprise Global User Group (VEGUG).
Connect with him online at LinkedIn