RSS

Script Browser add-in for PowerShell ISE

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

Advertisements
 
Leave a comment

Posted by on May 13, 2014 in Sharepoint

 

SharePoint: You can not upload files that are larger than 28 MB on a Windows Server 2008

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

 
Leave a comment

Posted by on May 29, 2013 in Sharepoint

 

Slow I/O in SQL Server

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

 
Leave a comment

Posted by on September 12, 2012 in Sharepoint

 

Cleanup document versioning in SharePoint 2007

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.

http://www.mukalian.com/blog/post/2011/04/10/PowerShell-Script-to-Delete-All-Versions-in-a-Document-Library.aspx

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).

 

 
Leave a comment

Posted by on August 13, 2012 in PowerShell, Sharepoint

 

WebClient service hang in the Stopping State

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.

 
2 Comments

Posted by on August 8, 2012 in Office Integration, Sharepoint

 

Site usage statistics out of sync – SharePoint

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.

 
Leave a comment

Posted by on May 3, 2012 in Sharepoint

 

Info: SSRS in SharePoint Integration Mode vs Native Mode

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:

architecture diagram

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.

 
Leave a comment

Posted by on February 24, 2012 in Reporting Services, Sharepoint