Microsoft has released a Script Browser add-in for PowerShell ISE to reuse script samples on the Internet, the following steps seem quite familiar to IT Pros: wandering through different script galleries, forums and blogs, switching back and forth between webpages and scripting environment, and countless download, copy and paste operations.
You can download the Script Browser add-in from here:http://www.microsoft.com/en-us/download/details.aspx?id=42525
One of my colleague was trying to troubleshoot the issue on uploading a large document into the newly built web application/farm. After I digg into the issue and found out that they have installed & configured the SharePoint 2007 on Windows 2008 R2.
So, we have to add the requestFiltering and maxAllowedContentLength elements in the web.config file to allow the user to upload the documents that are larger than 28MB. For more information, please refer the below Microsoft KB article.
http://support.microsoft.com/kb/944981
Most of the users does not know the Slow I/O could cause the SharePoint performances. The poor disk performance can cause the major impact on the SharePoint performance. One of the troubleshooting method would be use a Performance Monitor with counter measures to get a good picture of health of the disk I/O subsystem and any latency SQL Server is experiencing from its poor performance.
Microsoft had released a tool called “SQLIO Disk Subsystem Benchmark Tool” which can also be used to determine the I/O capacity of a given configuration. Also, you can use a tool such as IOMeter or sqlio.exe–both of which are freely downloadable–to benchmark the I/O performance of a disk.
You can download it from here: http://www.microsoft.com/downloads/details.aspx?familyid=9A8B005B-84E4-4F24-8D65-CB53442D9E19&displaylang=en
For more information: http://support.microsoft.com/kb/231619
Microsoft Engineer had posted a blog entry on Troubleshooting the Slow I/O in SQL Server. You can check his blog entry here: http://blogs.msdn.com/b/askjay/archive/2011/07/08/troubleshooting-slow-disk-i-o-in-sql-server.aspx
Customers always would like to keep store their all document versions but they don’t know how much space would take to keep storing the versions on the document.Document versions are always a bottleneck for the SharePoint administrators interms of sizing the quota limit.
Mike Mukalian had written an excellent powershell script to delete all the versions of document/files in the document library. For more information, please take a look at his blog entry.
Also, SP administrators would always like to automate this operation on a periodical schedule. In order to do that, 1. Create a scheduled task to run the script nightly/your own schedule and configure Powershell permissions on the server (run Set-ExecutionPolicy RemoteSigned from a Powershell prompt).
One of my customer had reported that she could not open the SharePoint document library folder from the shortcut. Actually, she created a shortcut for the document library explorer view. Some reasons she could not open the document library explorer view from the shortcut but she can able to access the site and able to open the explorer view from the URL.
After I digg into her machine and found out that WebClient Service was hang in the stopping state. I could not even stop/start the service using net command. Finally, I had to kill the process associated with the webclient service to stop the service and restart it afterwards.
Here is the command, I have used to kill the process associated with the webclient service.
taskkill /fi “imagename eq svchost.exe” /fi “Services eq WebClient” /F
Once I killed the process, I have restarted the service using net command.
Net start webclient
The issue has been resolved after I killed the process associated with WebClient and restarted the WebClient Service.
SYMPTOMS:
User not able to access the SharePoint Explorer View or Shortcut created on top of SharePoint Explorer View.
CAUSE:
WebClient Service might be stopped or hang in the stopping state
RESOLUTION:
1. Kill the process associated with the WebClient Service
taskkill /fi “imagename eq svchost.exe” /fi “Services eq WebClient” /F
2. Restart the WebClient
Net start webclient
Hope this helps.
Last week we had a peculiar issue on the SharePoint GUI(storman.aspx) which provides the information about Storage Space Allocation. The issue is, Storman.aspx(Storage Space Allocation) file was showing more than 100GB used space which is the subjected sitecollection had never reached to 100GB. We had check the database sizes(.mdf & .ldf) and those sizes are not even close to 100GB. Finally, we had concluded that there is some bug in the GUI or this usage statistics out of sync.
I end-up in creating the PowerShell script (as shown in below) to re-sync the usage statistics using RecalculateStorageUsed() Method.
foreach ($spsite in Get-SPSite -url *) {
$oStorage = $spsite.SPBase.Usage.Storage
Write-Host Old Storge: $oStorage
$spsite.SPBase.RecalculateStorageUsed()
$spsite.SPBase.Dispose()
$tSPSite = $spsite.GetSPObject()
$nStorage = $tSPSite.Usage.Storage
Write-Host $tSPSite.Url Updated from $oStorage to $nStorage
$tSPSite.Dispose()
}
Also, we could have use Gary Lapointe’s STSADM extension — which has gl-recalculateusage STSADM command to sync the site usage statistics on SharePoint.
Courtesy: http://msdn.microsoft.com
SQL Reporting Services in SharePoint Integration Mode
When you integrate a report server with an instance of a SharePoint product, items and properties are stored in the SharePoint content databases. This provides a deeper level of integration between the server technologies that effects how content is stored, secured, and accessed.
Storing report items and properties in SharePoint content databases allows you to browse SharePoint libraries for report server content types, secure items using the same permission levels and authentication provider that controls access to other business documents hosted on a SharePoint site, use the collaboration and document management features to check reports in and out for modification, use alerts to find out if an item has changed, and embed or customize the Report Viewer Web part on pages and sites within the application. If you have sufficient permissions within a SharePoint site, you can also generate report models from shared data sources and use Report Builder to create reports.
The report server continues to provide all data processing, rendering, and delivery. It also supports all scheduled report processing for snapshots and report history. The following diagram shows the server components together:
SQL Reporting Services in Native Mode
Reports are being hosted in a separate server as Native Mode and developers are adding the reports URL in to the SharePoint Pages. When we open a report by clicking the link in SharePoint page, SharePoint redirected to the Report Server URL. Thus, report server is running as an isolated server from the SharePoint.
