Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Citrix MetaFrame, SQL Server, and the DBA Expand / Collapse
Author
Message
Posted Saturday, May 11, 2002 12:00 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/citrix_metaframe.asp

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #4180
Posted Friday, March 2, 2007 8:13 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 12:11 PM
Points: 2,006, Visits: 6,081
Presentation Server 4.0 really takes this to the next level with the updated licensing model.

Additionally when you bring blades into the equation and remote deployment software (Altiris for example) which uses a SQL Server backend to house information, the DBA plays a critical role outside of what we might perceive as the typical OLTP or OLAP functions.




Shamless self promotion - read my blog http://sirsql.net
Post #348800
Posted Friday, March 2, 2007 9:22 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 12:52 PM
Points: 502, Visits: 750
We have been using Citrix extensively at several of our sites.  My only issue is that if am looking for a real fail over I use log shipping for the Citrix db, sorry replication too much a headache for such a small db


Post #348829
Posted Friday, March 2, 2007 10:26 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 9:53 AM
Points: 3,475, Visits: 584

There are other ways to stop user connections to SQL Server except for denying logins. Since the restore time will not be long as you sais the DB is not big, you can:

1.Unplug the network cable and work locally

2. Do not unplug the network cable. Go to SQL Server's Server Network Utility (2000) or SQL Server Configuration Manager (2005) and temp. disable the TCP/IP and Named Pipes. Leave just Shared Memory. Log in to the server using Terminal Services and work with SQL Server locally.

3. Do not unplug the network cable. Do not disable protocols. Change the listening port on the server and create an alias for this port on your client. Work remotely.




Regards,
Yelena Varshal

Post #348852
Posted Friday, March 2, 2007 11:50 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 12:11 PM
Points: 2,006, Visits: 6,081
I only have a locally maintained db for the Citrix portion, and run it on my distro cluster. It takes minimal resources and so is an ideal candidate for something like that.
I have strictly limited onsite DR, however the way that Citrix functions I have 24 hours to get everything up and running again, that's more than enough time to recover from backups should I need it, and the cluster takes care of potential hardware failures.




Shamless self promotion - read my blog http://sirsql.net
Post #348882
Posted Sunday, March 4, 2007 12:59 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, September 19, 2014 1:45 AM
Points: 434, Visits: 313
Just a quick add on - All of these scenarios do not cover the use of the enterprise level of citrix software. Although it still relies on the main database as dictated above, it also has the ability to create it's own datamart. This coupled with RS designer on SQL 2005 (The schema is downloadable from citrix) allows the production of some pretty nifty usage reports straight from the systems mouth - so to speak.
Post #349010
Posted Monday, March 5, 2007 5:12 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 12:11 PM
Points: 2,006, Visits: 6,081
The datamarts are great, but the data is not realtime, we've actually had to create some funky scenarios using DSQUERY in order to get real time information imported into SQL for usage information.



Shamless self promotion - read my blog http://sirsql.net
Post #349068
Posted Monday, March 5, 2007 1:06 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
To be honest, this article was written when 3.0 FR2 was the top of the line, if I remember right. There have been a lot of changes since then... especially with 4.5 out this summer (last time I checked). I really need to update this article, especially since folks are right in that there are better reporting solutions available now with 4.0.


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #349232
Posted Monday, March 5, 2007 1:23 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 12:11 PM
Points: 2,006, Visits: 6,081
XPe was what all of my items were based upon.

We are in the middle of a migration to 4.0 and will be looking at reporting functions within that which may be improved.

4.5 is very exciting from a Citrix standpoint with streaming applications and the opportunity for truly creating farms, but that's another story.




Shamless self promotion - read my blog http://sirsql.net
Post #349235
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse