Home
Hans Muster's Library tagged → View Popular
Optimizing SharePoint SQL Databases and Top Performance Killers - SharePoint Joel's SharePoint Land
I wanted to share a little bit more from my deck I delivered at Teched with Paul Learning. Had a great session, great attendance. What we got as a result was the need for more crossover information on SQL and SharePoint. I do recommend you start with this post on “Understanding the SharePoint SQL Databases” on SharePointForAll which I put together as post to better explain how the data is spread out and to help better understand the differences between the different SharePoint databases.
Sanjay Narang's thoughts on SharePoint : SharePoint (Performance, Stress ) Load Testing
SharePoint (Performance, Stress ) Load Testing
Whenever I've helped my customers in performance testing and analysis of SharePoint, I get one common question: Can you tell us more about "SharePoint Load Testing" and links where I can learn more? Doing a quick web search on "SharePoint Load Testing" or "SharePoint Performance Testing" - you get all kinds of results such as data population tools, performance tuning techniques, handling large lists etc. However, it's not very easy to get results about, How to go about load testing SharePoint, what are the counters that i should measure, where can i find real life bench mark results of SharePoint? That's exactly, what I am trying to in this post. I'm trying to cover all the resources that I know about load testing. I wouldn't be covering much about Performance Tuning and Analysis.
The wrong way to iterate through SharePoint SPList Items
There are multiple ways to iterate through the items of a SharePoint list by using the SharePoint Object Model. One approach - which I’ve seen before in a real life SharePoint Application - may work fine on the developers machine or on very tiny lists. But it is going to ruin your performance once executed on a list that exceeds a couple of hundred items.
Download details: Analyzing SharePoint Products and Technologies Usage
This paper discusses how to gather and analyze SharePoint Products and Technologies data.
Glary Utilities
Glary Utilities offers numerous powerful and easy-to-use system tools and utilities to fix, speed up, maintain and protect your PC.
It allows you to clean common system junk files, as well as invalid registry entries and Internet traces. You can manage and delete browser add-ons, analyze disk space usage and find duplicate files. You can also view and manage installed shell extensions, encrypt your files from unauthorized access and use, split large files into smaller manageable files and then rejoin them. Furthermore, Glary Utilities includes the options to optimize memory, find, fix, or remove broken Windows shortcuts, manage the programs that start at Windows startup and uninstall software. Other features include secure file deletion, an Empty Folder finder and more.
All Glary Utilities tools can be accessed through an eye-pleasing and totally simplistic interface.
Category
Modules
Clean Up & Repair
Disk Cleaner
Removes junk data from your disks and recovers disk space
Registry Cleaner
Scans and cleans up your registry to improve your system's performance.
Shortcuts Fixer
Corrects the errors in your startmenu & desktop shortcuts
Uninstall Manager
Uninstalls programs completely that you don't need any more
Optimize & Improve
Startup Manager
Manages programs which run automatically on startup
Memory Optimizer
Monitors and optimizes free memory in the background
Context Menu Manager
Manages the context-menu entries for files, folders...
Privacy & Security
Tracks Eraser
Erases all the traces,evidences,cookies,internet history and more
File Shredder
Erases files permanently so that no one can recover them
File Undelete
Quick and effective way to retrieve accidentally deleted files
File Encrypter and Decrypter
Protects your files from unauthorized access and use.
Files & Folders
Disk Analysis
Shows you the disk space usage of your files and folders
Duplicate Files Finder
Searches for space-wasting and error producing duplicate files
Empty Folders Finder
Finds and removes e
Steven Haden's Blog : Database Maintenance for Microsoft SharePoint® Products and Technologies
Database maintenance is essential for the health and the performance of your SharePoint® Products and Technologies applications (EPM and/or MOSS).
Check these white papers:
Database Maintenance for Microsoft® SharePoint® Products and Technologies
http://go.microsoft.com/fwlink/?LinkId=111531&clcid=0x409
Planning and Monitoring SQL Server Storage for SharePoint: Performance Recommendations and Best Practices
http://go.microsoft.com/fwlink/?LinkID=105623&clcid=0x409
and this KB article
How to defragment Windows SharePoint Services 3.0 databases and SharePoint Server 2007 databases (http://go.microsoft.com/fwlink/?LinkId=110843&clcid=0x409)
SQL SPY
-
SQL SPY was designed as a tool to display, monitor and report on valuable SQL
Server information.
Selected Tags
Related Tags
Sponsored Links
Top Contributors
Groups interested in performa...
-
Rails Performance Optimization
Items: 7 | Visits: 60
Created by: Avdi Grimm
-
Consistent Hashing
Items: 8 | Visits: 85
Created by: Arrix Z
Highlighter, Sticky notes, Tagging, Groups and Network: integrated suite dramatically boosting research productivity. Learn more »
Join Diigo