Wednesday, December 10, 2014

SharePoint - Suggested thresholds (over time)



  All is good Pay Attention Houston, we have a problem
CPU Usage  < 60%  60-90% > 90%
Memory Free % > 50% free 10-50% free <10% free
Disk Read/Writes/sec 0-15 15-25 Ø25
Disk Time (use only to see use over time)      
Avg. Disk sec/Read  < 15 ms > 15 ms > 20 ms
Avg. Disk sec/Write 
Avg. Disk sec/Transfer
Network bandwidth – bytes total < 40%  41-65% > 65%
Network Latency – output queue length 0 2-Jan > 2

Wednesday, November 12, 2014

Manage site collection upgrades to SharePoint 2013


http://technet.microsoft.com/en-us/library/jj219599(v=office.15).aspx

Manage site collection upgrades to SharePoint 2013

SharePoint 2013
2 out of 2 rated this helpful - Rate this topic
 
Applies to: SharePoint Server 2013, SharePoint Foundation 2013
Topic Last Modified: 2014-07-03
Summary: Learn how farm administrators can manage the upgrade queue and throttling settings and upgrade site collections to SharePoint 2013.
Even though site collection administrators can now upgrade their own sites to SharePoint 2013, server farm administrators can still control when and whether a site collection is upgraded by managing the upgrade queue. You can also view and manage the upgrade throttling settings for a web application or content database to manage your farm's performance for site collection upgrades.

Before you begin to upgrade site collections to SharePoint 2013

Farm administrators can control settings for site collection upgrade, such as notifications, throttling, and the upgrade queue, and can upgrade site collections by using Windows PowerShell. Before you change these settings or upgrade a site collection, you should understand the settings and the implications for making changes. For more information about the settings for site collection upgrade, see Plan for site collection upgrades in SharePoint 2013. For information about how to upgrade a site collection from the Site Settings page, see Upgrade a site collection to SharePoint 2013.
NoteNote:
Because SharePoint 2013 runs as websites in Internet Information Services (IIS), administrators and users depend on the accessibility features that browsers provide. SharePoint 2013 supports the accessibility features of supported browsers. For more information, see the following resources:

Control upgrade notifications and self-service upgrade

When a site collection is available to upgrade, site collection administrators see a status bar on their sites indicating that they can upgrade them. They can choose to upgrade the site collection then or be reminded later. You can control settings for these notifications and control whether site collection administrators can upgrade their site collections. For more information about these properties, see Determine whether site collection administrators are notified about upgrades and plan settings for upgrade notifications.
To view the upgrade notification and self-service upgrade settings by using Windows PowerShell
  1. Verify that you have the following memberships:
    • securityadmin fixed server role on the SQL Server instance.
    • db_owner fixed database role on all databases that are to be updated.
    • Administrators group on the server on which you are running the Windows PowerShell cmdlets.
    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.
    NoteNote:
    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about Windows PowerShell permissions, seeAdd-SPShellAdmin.
  2. On the Start menu, click All Programs.
  3. Click Microsoft SharePoint 2013 Products.
  4. Click SharePoint 2013 Management Shell.
  5. At the Windows PowerShell command prompt, type the following commands to view the upgrade notification settings for a web application:
    $wa=Get-SPWebApplication <URL>
    $wa.UpgradeReminderDelay
    $wa.UpgradeMaintenanceLink
    
    Where:
    • <URL> is URL for the web application that you want to check.
    This command returns the Upgrade reminder delay setting for the specified web application.
  6. At the Windows PowerShell command prompt, type the following command to view the self-service upgrade setting for a site collection:
    $site=Get-SPSite <URL>
    $site.AllowSelfServiceUpgrade=<Value>
    
    
    Where:
    • <URL> is URL for the site collection that you want to affect.
    • <Value> is either 'true' to allow site collection administrators to upgrade the site, or 'false' to not show them the notification and not allow them to upgrade.
For more information, see Get-SPWebApplication and Get-SPSite.
To change the upgrade notification and self-service upgrade settings for a web application by using Windows PowerShell
  1. Verify that you have the following memberships:
    • securityadmin fixed server role on the SQL Server instance.
    • db_owner fixed database role on all databases that are to be updated.
    • Administrators group on the server on which you are running the Windows PowerShell cmdlets.
    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.
    NoteNote:
    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about Windows PowerShell permissions, seeAdd-SPShellAdmin.
  2. On the Start menu, click All Programs.
  3. Click Microsoft SharePoint 2013 Products.
  4. Click SharePoint 2013 Management Shell.
  5. At the Windows PowerShell command prompt, type the following command to change the upgrade notification settings for a web application:
    $wa=Get-SPWebApplication <URL>
    $wa.UpgradeReminderDelay=<Value>
    $wa.UpgradeMaintenanceLink='<LinkURL>'
    
    
    Where:
    • <URL> is URL for the web application that you want to affect.
    • <Value> is the numeric value that you want to set for the delay (for example, 10 for 10 days).
    • <LinkURL> is a link where the user can find more information.
  6. At the Windows PowerShell command prompt, type the following command to change the self-service upgrade setting for a site collection:
    $site=Get-SPSite <URL>
    $site.AllowSelfServiceUpgrade=<Value>
    
    
    Where:
    • <URL> is URL for the site collection that you want to affect.
    • <Value> is either 'true' to allow site collection administrators to upgrade the site, or 'false' to not show them the notification and not allow them to upgrade.
For more information, see Get-SPWebApplication and Get-SPSite.

Control the compatibility range for site creation modes

You can control which mode (2010 or 2013, or both) can be used when a user creates a site collection. The CompatibilityRange property on a web application controls the site modes available for a web application. You can view or change the settings for CompatibilityRange by using Windows PowerShell.
To view the compatibility range for site creation modes for a web application by using Windows PowerShell
  1. Verify that you have the following memberships:
    • securityadmin fixed server role on the SQL Server instance.
    • db_owner fixed database role on all databases that are to be updated.
    • Administrators group on the server on which you are running the Windows PowerShell cmdlets.
    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.
    NoteNote:
    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about Windows PowerShell permissions, seeAdd-SPShellAdmin.
  2. On the Start menu, click All Programs.
  3. Click Microsoft SharePoint 2013 Products.
  4. Click SharePoint 2013 Management Shell.
  5. At the Windows PowerShell command prompt, type the following commands to view the compatibility range settings for a web application:
    $wa=Get-SPWebApplication <URL>
    # Stores the web application at that URL as a variable 
    $wa.CompatibilityRange
    # Returns the CompatibilityRange for the specified web application
    
    Where:
    • <URL> is URL for the web application that you want to check.
    This command returns the compatibility range for the specified web application. For example:
    MaxCompatibilityLevel   MinCompatibilityLevel  DefaultCompatibilityLevel   Singular
    ---------------------   ---------------------  -------------------------   --------
                    15                    14                           15         False
    
    
  6. At the Windows PowerShell command prompt, type the following commands to view the maximum, minimum, and default settings for a specific range:
    [Microsoft.SharePoint.SPCompatibilityRange]::<RangeName>
    
    Where:
    • RangeName is one of the following values: OldVersionsNewVersionAllVersions.
    This command returns the compatibility range for the specified value. For example, for NewVersion:
    MaxCompatibilityLevel   MinCompatibilityLevel  DefaultCompatibilityLevel   Singular
    ---------------------   ---------------------  -------------------------   --------
                   15                     15                           15         True
    
    
For more information, see Get-SPWebApplication.
To change compatibility range for site creation modes for a web application by using Windows PowerShell
  1. Verify that you have the following memberships:
    • securityadmin fixed server role on the SQL Server instance.
    • db_owner fixed database role on all databases that are to be updated.
    • Administrators group on the server on which you are running the Windows PowerShell cmdlets.
    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.
    NoteNote:
    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about Windows PowerShell permissions, seeAdd-SPShellAdmin.
  2. On the Start menu, click All Programs.
  3. Click Microsoft SharePoint 2013 Products.
  4. Click SharePoint 2013 Management Shell.
  5. At the Windows PowerShell command prompt, type the following command to change the compatibility range settings to a specific range:
    $wa=Get-SPWebApplication <URL> # Stores the web application at that URL as a variable $wa.CompatibilityRange = [Microsoft.SharePoint.SPCompatibilityRange]::<RangeName> # Specifies which range to use $wa.Update() # Updates the CompatibilityRange setting to use only the range you specified $wa.CompatibilityRange # Returns the new CompatibilityRange for the web application 
    Where:
    • <URL> is URL for the web application that you want to change.
    • RangeName is one of the following values: OldVersionsNewVersionAllVersions.
  6. At the Windows PowerShell command prompt, type the following command to change the values for the CompatibilityRange manually:
    $wa=Get-SPWebApplication <URL> # Stores the web application at that URL as a variable $range = New-Object Microsoft.SharePoint.SPCompatibilityRange(<Integer>,<Integer>) # Creates a new compatibility range from <Integer> to <Integer> $wa.CompatibilityRange = $range # Specifies which range to use $wa.Update() #Updates the CompatibilityRange setting to use only the range you specified with $range $wa.CompatibilityRange # Returns the new CompatibilityRange for the web application 
    Where:
    • <URL> is URL for the web application that you want to change.
    • Integer is a number to use as the minimum or maximum value. For example, (14,15) would set the MinCompatibilityLevel to 14 (2010) and the MaxCompatibilityLevel to 15 (2013). The DefaultCompatibilityLevel is automatically set to the lower of the MaxCompatibilityLevel and the current major version (for example, 15).
    This command sets and then returns the range that you specified. For example:
    MaxCompatibilityLevel   MinCompatibilityLevel   DefaultCompatibilityLevel   Singular
    ---------------------   ---------------------   -------------------------   --------
                    15                     14                           15         False
    
    
For more information, see Get-SPWebApplication.

Control the queue for upgrades of sites to SharePoint 2013

Every site that is set to upgrade is added to the queue, even if it is processed immediately. A site is removed from the queue after it is upgraded, or if it has encountered an error that must be addressed by a site collection or server administrator. If an unexpected failure occurs during the process (such as a power outage or service interruption), the site remains in the queue and the timer service will try the upgrade again automatically. Server farm administrators can manage the queue to remove a site from the queue, add a site to the queue, or upgrade a site manually.
Server farm administrators can manage the queue to do the following:
  • Determine site collections that are in the upgrade queue.
    Each web application has its own upgrade queue. You can show the sites that are in the queue for a specific content database associated with that web application.
  • See all sites that are currently being upgraded.
    You can view the queue and filter it to show only the sites that are currently being upgraded for a specific content database.
  • Add a site collection to the upgrade queue.
    If you want to upgrade a site collection, you can add it to the queue.
  • Remove a site collection from the upgrade queue.
    You can remove a site collection from the upgrade queue. Stop the timer job, remove the site from the queue, and then restart the timer job to resume upgrade for the remaining sites in the queue. You cannot remove a site collection from the queue if it is currently being upgraded.
The following procedure contains steps to view and manage the site collection upgrade queue.
To manage the upgrade queue by using Windows PowerShell
  1. Verify that you have the following memberships:
    • securityadmin fixed server role on the SQL Server instance.
    • db_owner fixed database role on all databases that are to be updated.
    • Administrators group on the server on which you are running the Windows PowerShell cmdlets.
    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.
    NoteNote:
    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about Windows PowerShell permissions, seeAdd-SPShellAdmin.
  2. On the Start menu, click All Programs.
  3. Click Microsoft SharePoint 2013 Products.
  4. Click SharePoint 2013 Management Shell.
  5. To view all site collections in the queue for a content database, at the Windows PowerShell command prompt, type the following command:
    Get-SPSiteUpgradeSessionInfo -ContentDatabase <DatabaseName> -ShowInProgress -ShowCompleted -ShowFailed |ft
    
    Where:
    • <DatabaseName> is name of the database that you want to check. You can also use the GUID for the database instead of the name.
    For more information, see Get-SPSiteUpgradeSessionInfo.
  6. To see all sites that are currently being upgraded, at the Windows PowerShell command prompt, type the following command:
    Get-SPSiteUpgradeSessionInfo -ContentDatabase <DatabaseName> -ShowInProgress
    
    Where:
    • <DatabaseName> is name of the database that you want to check. You can also use the GUID for the database instead of the name.
    For more information, see Get-SPSiteUpgradeSessionInfo.
  7. To see whether a particular site is in the queue, at the Windows PowerShell command prompt, type the following command:
    Get-SPSiteUpgradeSessionInfo -Site <http://site>
    
    Where:
    • <http://site> is URL for the site collection you want to add to the upgrade queue.
    For more information, see Get-SPSiteUpgradeSessionInfo.
  8. To add a site collection to the upgrade queue, at the Windows PowerShell command prompt, type the following command:
    Upgrade-SPSite <http://site> -VersionUpgrade -QueueOnly
    
    Where:
    • <http://site> is URL for the site collection you want to add to the upgrade queue.
    For more information, see Upgrade-SPSite.
  9. To remove a site collection from the upgrade queue, at the Windows PowerShell command prompt, type the following command:
    Remove-SPSiteUpgradeSessionInfo -Identity <URL>
    
    Where:
    • <URL> is URL for the site collection you want to add to the upgrade queue.
    For more information, see Remove-SPSiteUpgradeSessionInfo.

Control site throttle settings for upgrade to SharePoint 2013

You can view and change the upgrade throttle settings for a content database and web application by viewing and setting the SPContentDatabase.ConcurrentSiteUpgradeSessionLimit andSPWebApplication.SiteUpgradeThrottleSettings properties. For descriptions of the properties that control throttle levels and the default values, see Plan for site collection upgrades in SharePoint 2013.
For more information about web application properties, see SPWebApplication Properties. For more information about content database properties, see SPContentDatabase Properties.
The following procedure provides steps to view upgrade throttling settings for a web application.
To view the upgrade throttle settings for a web application by using Windows PowerShell
  1. Verify that you have the following memberships:
    • securityadmin fixed server role on the SQL Server instance.
    • db_owner fixed database role on all databases that are to be updated.
    • Administrators group on the server on which you are running the Windows PowerShell cmdlets.
    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.
    NoteNote:
    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about Windows PowerShell permissions, seeAdd-SPShellAdmin.
  2. On the Start menu, click All Programs.
  3. Click Microsoft SharePoint 2013 Products.
  4. Click SharePoint 2013 Management Shell.
  5. At the Windows PowerShell command prompt, type the following command:
    $wa = Get-SPWebApplication <URL> $wa.SiteUpgradeThrottleSettings 
    Where:
    • <URL> is URL for the web application that you want to check.
    This command returns the set of throttling settings for the specified web application. For example:
    AppPoolConcurrentUpgradeSessionLimit : 5
    UsageStorageLimit                    : 10
    SubwebCountLimit                     : 10
    Name                                 :
    TypeName                             : Microsoft.SharePoint.Administration.SPSiteUpgradeThrottleSettings
    DisplayName                          :
    Id                                   : ca76dda0-7050-4c6b-a126-05917da39f8a
    Status                               : Online
    Parent                               : SPWebApplication Name=SharePoint - 80
    Version                              : 8222
    Properties                           : {}
    Farm                                 : SPFarm Name=SharePoint_ConfigUpgradedPersistedProperties          : {}
    
For more information, see Get-SPWebApplication.
You can change the upgrade throttle settings for a web application. The following procedure provides steps to change the upgrade throttling settings for a web application.
To change the upgrade throttle settings for a web application by using Windows PowerShell
  1. Verify that you have the following memberships:
    • securityadmin fixed server role on the SQL Server instance.
    • db_owner fixed database role on all databases that are to be updated.
    • Administrators group on the server on which you are running the Windows PowerShell cmdlets.
    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.
    NoteNote:
    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about Windows PowerShell permissions, seeAdd-SPShellAdmin.
  2. On the Start menu, click All Programs.
  3. Click Microsoft SharePoint 2013 Products.
  4. Click SharePoint 2013 Management Shell.
  5. At the Windows PowerShell command prompt, type the following command:
    $wa=Get-SPWebApplication <URL>
    $wa.SiteUpgradeThrottleSettings.AppPoolConcurrentUpgradeSessionLimit=<Value>
    $wa.SiteUpgradeThrottleSettings.UsageStorageLimit=<Value>
    $wa.SiteUpgradeThrottleSettings.SubwebCountLimit=<Value>
    
    
    Where:
    • <URL> is URL for the web applications that you want to affect.
    • Value is the numeric value that you want to set for that limit (for example, 8).
    This command changes the throttling settings for a web application to the value that you supply.
For more information, see Set-SPWebApplication.
The following procedure provides steps to view upgrade throttling settings for a content database.
To view the throttle settings for a content database by using Windows PowerShell
  1. Verify that you have the following memberships:
    • securityadmin fixed server role on the SQL Server instance.
    • db_owner fixed database role on all databases that are to be updated.
    • Administrators group on the server on which you are running the Windows PowerShell cmdlets.
    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.
    NoteNote:
    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about Windows PowerShell permissions, seeAdd-SPShellAdmin.
  2. On the Start menu, click All Programs.
  3. Click Microsoft SharePoint 2013 Products.
  4. Click SharePoint 2013 Management Shell.
  5. At the Windows PowerShell command prompt, type the following command:
    $db = Get-SPContentDatabase <DatabaseName> # Stores the database name as a variable to use in the next command 
    $db.ConcurrentSiteUpgradeSessionLimit # Returns the value for the limit for that database 
    Where:
    • <DatabaseName> is name of the database that you want to check. You can also use the GUID for the database instead of the name.
    This command returns the set of throttling settings for the specified content database.
For more information, see Get-SPContentDatabase.
You can change the upgrade throttle settings for a content database. The following procedure provides steps to change the upgrade throttling settings for a content database.
To change the throttle settings for a content database by using Windows PowerShell
  1. Verify that you have the following memberships:
    • securityadmin fixed server role on the SQL Server instance.
    • db_owner fixed database role on all databases that are to be updated.
    • Administrators group on the server on which you are running the Windows PowerShell cmdlets.
    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.
    NoteNote:
    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about Windows PowerShell permissions, seeAdd-SPShellAdmin.
  2. On the Start menu, click All Programs.
  3. Click Microsoft SharePoint 2013 Products.
  4. Click SharePoint 2013 Management Shell.
  5. At the Windows PowerShell command prompt, type the following commands:
    $db = Set-SPContentDatabase <DatabaseName> # Stores the database name as a variable to use in the next command 
    $db.ConcurrentSiteUpgradeSessionLimit=<value> # Changes the limit to the value you specify. 
    Where:
    • <DatabaseName> is name of the database that you want to affect. You can also use the GUID for the database instead of the name.
    • <value> is a numeric value to set the property to, such as 9.
    This command changes the throttling settings for the specified content database to the value that you supply.
For more information, see Set-SPContentDatabase.

Create upgrade evaluation site collections by using Windows PowerShell

Site collection administrators can request a preview of their site collection. This preview site is called an upgrade evaluation site collection. Farm administrators can request an upgrade evaluation site collection by using Windows PowerShell.
To request an upgrade evaluation site collection by using Windows PowerShell
  1. Verify that you have the following memberships:
    • securityadmin fixed server role on the SQL Server instance.
    • db_owner fixed database role on all databases that are to be updated.
    • Administrators group on the server on which you are running the Windows PowerShell cmdlets.
    • Either a site collection administrator or be granted full control (for repair mode) for the web application by policy. For more information about permission policies for web applications, see Manage permission policies for a web application in SharePoint 2013.
    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.
    NoteNote:
    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about Windows PowerShell permissions, seeAdd-SPShellAdmin.
  2. On the Start menu, click All Programs.
  3. Click Microsoft SharePoint 2013 Products.
  4. Click SharePoint 2013 Management Shell.
  5. At the Windows PowerShell command prompt, type the following command:
    Request-SPUpgradeEvaluationSiteCollection -identity URL to site
    
    Where:
    • URL to site is the URL to a site collection in 2010 mode.
For more information, see Request-SPUpgradeEvaluationSite.

Upgrade site collections by using Windows PowerShell

You can upgrade a single site collection or all site collections in a specific database by using Windows PowerShell.
To upgrade a single site collection in a database by using Windows PowerShell
  1. Verify that you have the following memberships:
    • securityadmin fixed server role on the SQL Server instance.
    • db_owner fixed database role on all databases that are to be updated.
    • Administrators group on the server on which you are running the Windows PowerShell cmdlets.
    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.
    NoteNote:
    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about Windows PowerShell permissions, seeAdd-SPShellAdmin.
  2. On the Start menu, click All Programs.
  3. Click Microsoft SharePoint 2013 Products.
  4. Click SharePoint 2013 Management Shell.
  5. At the Windows PowerShell command prompt, type the following command:
    Upgrade-SPSite <http://site> -VersionUpgrade [-Unthrottled]
    
    Where:
    • <http://site> is the URL for the site collection.
    • Add the option -Unthrottled option to skip the site collection upgrade queue and start the upgrade immediately.
This cmdlet upgrades the specific site collection to 2013 mode. For more information, see Upgrade-SPSite.
To upgrade all site collections in a database, use Windows PowerShell. However, because sites can continue to run in 2010 mode in the SharePoint 2013 environment, this is not a necessary procedure for most environments. If you do choose to upgrade all site collections immediately, site collection owners do not have an opportunity to use an upgrade evaluation site to preview the new user interface or change their original site before upgrading. We do not recommend that you upgrade all site collections immediately as part of your initial upgrade. However, you might want to upgrade all site collections after some time has passed and all customizations were verified in 2013 mode.
To upgrade all site collections in a database by using Windows PowerShell
  1. Verify that you have the following memberships:
    • securityadmin fixed server role on the SQL Server instance.
    • db_owner fixed database role on all databases that are to be updated.
    • Administrators group on the server on which you are running the Windows PowerShell cmdlets.
    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.
    NoteNote:
    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about Windows PowerShell permissions, seeAdd-SPShellAdmin.
  2. On the Start menu, click All Programs.
  3. Click Microsoft SharePoint 2013 Products.
  4. Click SharePoint 2013 Management Shell.
  5. At the Windows PowerShell command prompt, type the following command:
    Get-SPSite -ContentDatabase <DBName> -Limit All | Upgrade-SPSite -VersionUpgrade -QueueOnly
    
    Where:
    • <DBName> is the name of the content database for which you want to upgrade all site collections.
    The -QueueOnly parameter adds the site collections to the upgrade queue. This allows the timer job to perform parallel upgrades when it is possible and can save time. The sites are upgraded in the order in which they are added to the queue.
This cmdlet upgrades all site collections in the specific content database to 2013 mode.

View upgrade status by using Windows PowerShell

You can view upgrade status for all databases, for a single site collection, or for all site collections.
To view upgrade status for a single site collection by using Windows PowerShell
  1. Verify that you have the following memberships:
    • securityadmin fixed server role on the SQL Server instance.
    • db_owner fixed database role on all databases that are to be updated.
    • Administrators group on the server on which you are running the Windows PowerShell cmdlets.
    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.
    NoteNote:
    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about Windows PowerShell permissions, seeAdd-SPShellAdmin.
  2. On the Start menu, click All Programs.
  3. Click Microsoft SharePoint 2013 Products.
  4. Click SharePoint 2013 Management Shell.
  5. At the Windows PowerShell command prompt, type the following command:
    Get-SPSiteUpgradeSessionInfo -Site <http://site>
    
    Where:
    • <http://site> is the URL of the site collection.
    This cmdlet returns the upgrade status for the specified site collection together with information about the upgrade session and a link to the log files for more information. For more information, see Get-SPSiteUpgradeSessionInfo.
  6. Or, you can use the following command to view the information about a specific site collection upgrade:
    $sc = Get-SPSite <http://site>
    # Sets a variable for the site collection
    $sc.CompatibilityLevel
    # Returns the compatibility level for the site collection (either 14 or 15 for 2010 or 2013 mode)
    $sc.UpgradeInfo
    # Returns the upgrade information for the site collection
    
    Where:
    • <http://site> is the URL of the site collection.
    This command returns the compatibility level and upgrade information (such as a pointer to the log file) for the specified site collection. If the compatibility level is "15," then it has been upgraded to 2013 mode. For more information, see Get-SPSite.
To view upgrade status for a single database by using Windows PowerShell
  1. Verify that you have the following memberships:
    • securityadmin fixed server role on the SQL Server instance.
    • db_owner fixed database role on all databases that are to be updated.
    • Administrators group on the server on which you are running the Windows PowerShell cmdlets.
    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.
    NoteNote:
    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about Windows PowerShell permissions, seeAdd-SPShellAdmin.
  2. On the Start menu, click All Programs.
  3. Click Microsoft SharePoint 2013 Products.
  4. Click SharePoint 2013 Management Shell.
  5. At the Windows PowerShell command prompt, type the following command:
    Get-SPSiteUpgradeSessionInfo -ContentDatabase <DatabaseName> -ShowInProgress -ShowCompleted -ShowFailed
    
    Where:
    • <DatabaseName> is the name of the database that you want to check.
    This cmdlet returns any site collections that have an upgrade in progress, completed, or failed and lists their status, plus a link to the log files for more information. You can use only one parameter to find only in progress, completed, or failed upgrades. For more information, see Get-SPSiteUpgradeSessionInfo.
To view upgrade status for all site collections by using Windows PowerShell
  1. Verify that you have the following memberships:
    • securityadmin fixed server role on the SQL Server instance.
    • db_owner fixed database role on all databases that are to be updated.
    • Administrators group on the server on which you are running the Windows PowerShell cmdlets.
    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.
    NoteNote:
    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about Windows PowerShell permissions, seeAdd-SPShellAdmin.
  2. On the Start menu, click All Programs.
  3. Click Microsoft SharePoint 2013 Products.
  4. Click SharePoint 2013 Management Shell.
  5. At the Windows PowerShell command prompt, type the following command:
    Get-SPSite -Limit All
    
This cmdlet returns the URL for all site collections in the environment and the compatibility level (14 or 15) for each site collection.