20150702-citrixxendesktop-sql Server

# #好久一段时间没有更新学习笔记, Inertia is something to overcome.

This Saturday, July 4, is about to practice a thing that has not been done before. Why use the word practice? Because, Citrixxendesktop also not have not touched, just before are do POC, really did not in production site tried. And before the POC is a new installation, better control. But this is update, hope everything goes well. Be prepared for a tense and exciting mood.

Environment existing environment:citrixxendeskptop (XD) 5.6, OS:08R2

Target: From 5.6 Update to 7.1

Xd-sql Server

If it is installed by default, the database should be installed on the same machine as the delivery Controller. But a lot of security needs, the database will be installed in addition to a separate machine running. This time the environment happens to be independent of the database, so before doing the update, it is necessary to check the database is now running state.

1. SQL Server version

   There are many ways to check the version of a database, as described in the following links https://support.microsoft.com/en-us/kb/321185

   I am accustomed to use the following

   1) Open SQL Server Explorer right-click SQL Server Properties. You can see the basic information for SQL Server.

   2) Query (recommended)

SELECT serverproperty (' Edition ') as edition, Serverproperty (' ProductVersion ') as Productversion,serverproperty (' ProductLevel ') as ProductLevel

The result is displayed

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6F/38/wKioL1WU-pXjrImWAAFVTP1JWwk106.jpg "title=" SQL1. PNG "alt=" Wkiol1wu-pxjrimwaafvtp1jwwk106.jpg "/>

3) Query

[Email protected] @Version

will show a simple line similar to the information mentioned in the link above

Microsoft SQL Server (SP1)-10.0.2531.0 (X64) Mar 29 2009
10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Express
Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600:)

2. SQL Server Connection

For security reasons, SQL Server does not recommend reading and writing data if it needs update. So before the update, it is necessary to check the active links now. The following 2nd and 3rd methods are recommended.

1) Right-click SQL Server and select "Activity Monitor" to see the information on the right. It is recommended to use the local admin to view, because if the permissions are not enough, is not able to view or can not view the complete.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6F/3B/wKiom1WU_dqgf38lAATb8241bsw447.jpg "title=" Sql2.png "alt=" Wkiom1wu_dqgf38laatb8241bsw447.jpg "/>

2) QUERY (most concise)

SELECT db_name (dbid) as DBName, hostname as hostname, COUNT (dbid) as Numberofconnections, loginame as Lo Ginamefrom Sys.sysprocesseswhere Dbid>0group by Dbid,loginame,hostnameorder by Db_name (dbid)

The following result will appear

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6F/39/wKioL1WVAZiSWxfYAAFx3yFK1go300.jpg "title=" sql3. PNG "alt=" Wkiol1wvaziswxfyaafx3yfk1go300.jpg "/>

3) QUERY

EXEC Sp_who2 ' active '; GO

This statement will appear after the most comprehensive connection information, with the connection Session ID as the identity, in addition to display the last statement of data, there are the following.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6F/39/wKioL1WVAovgg3I_AAEbY51X9hU066.jpg "title=" Sql4. PNG "alt=" Wkiol1wvaovgg3i_aaeby51x9hu066.jpg "/>

4) QUERY

Use master; Goexec sp_who ' active '; GO

This statement is a condensed version of the above statement. I seldom use it. The output is the following result.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6F/39/wKioL1WVBHKwFrkZAAEdGuO_Ejo455.jpg "title=" SQL5. PNG "alt=" Wkiol1wvbhkwfrkzaaedguo_ejo455.jpg "/>

This article from "Gentleman Familiar" blog, reprint please contact the author!

20150702-citrixxendesktop-sql Server