1
POPSDBCC DROPCLEANBUFFERS I saw one of my colleagues using this procedure. I haven't used it myself, but I think I'm about to start experimenting with it. I think the part about executing a CHECKPOINT first makes sense.
1
POPSfn_virtualfilestats Not exactly sure how this might help, but it's available... I found it in SQL Server Magazine's website and thought I'd clip it.
1
POPSYou can use an external editor with sqlcmd I haven't really done much with SQL Server 2005. I'm getting myself in the situation where I must, though, as I am using it as the platform for capturing performance counter data. I let the database grow way out of pocket and am now suffering the consequences. I know back with SQL Server 2000 you could use the osql utility to run commands and scripts from the command line. Looks like you do the same thing using sqlcmd for SQL Server 2005. I'll probably be using this to execute a command file to shrink the transaciton log when it gets too big. I'll be using Performance Monitor's Alert feature to detect when the script needs to be run and have the action be to log a record in the application event log and to execute the script to truncate the log. The other alternative is to use SQL Server Agent to execute a cleanup script in a more meaningful manner. Consider my first suggestion a failsafe.
0
POPSDesign queries using SHOWPLAN turned on Yeah, this makes a lot of sense to do. I hadn't thought of it like that before. I've found myself turning Execution Plan on when working on complex procedures, but I don't make it part of my regular habit. I think this practice will be good for me to start doing.
1
POPSAvoid Temp Tables I've been working on removing the use of temp tables in some of the procedures that I've inherited. I think it's helping with the database performance.
0
POPSTable Spool should alert you to a potential problem I was looking at a query plan today and saw a Table Spool icon. I had never seen one of those before. I thought that it might not be so great. I found this little bit of text on spooling data to work tables and thought it was interesting.
0
POPSOracle RAC Overview Oracle RAC technology sounds pretty cool. I've worked with Microsoft SQL Server clusters before, but never with Oracle. I'm interested in learning more, especially since it's looking like I'll need to deal with Oracle a lot more in my next job. :-)
133
POPS104 Performance Tips for Windows XP. The topics are in the clip. Visit the source for the 99 individual tips and how to do them. Updated Source Link As Of 10-29-06, thanks paul: http://www.pcstats.com/articleview.cfm?articleID=1681
Newest Clips
see Newest Clips
Pops
Comments
Tags
1
Most Pops
Print
Save
Turn on live update