Citrix MetaFrame, SQL Server, and the DBA

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brian Kelley » Citrix MetaFrame, SQL Server, and the DBA

Citrix MetaFrame, SQL Server, and the DBA

Rate Topic

Display Mode

Topic Options

Author

Message

K. Brian Kelley

Posted Saturday, May 11, 2002 12:00 AM

Keeper of the Duck

Group: Moderators
Last Login: Today @ 1:55 PM
Points: 6,584, Visits: 1,789

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

Nicholas Cain

Posted Friday, March 02, 2007 8:13 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 4:27 PM
Points: 2,007, Visits: 6,040

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

timscronin

Posted Friday, March 02, 2007 9:22 AM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, May 10, 2013 7:54 AM
Points: 472, Visits: 686

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

Yelena Varshal

Posted Friday, March 02, 2007 10:26 AM

Hall of Fame

Group: General Forum Members
Last Login: Monday, July 30, 2012 10:42 AM
Points: 3,434, Visits: 519

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

Nicholas Cain

Posted Friday, March 02, 2007 11:50 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 4:27 PM
Points: 2,007, Visits: 6,040

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

Paul Smith-221741

Posted Sunday, March 04, 2007 12:59 PM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 427, Visits: 276

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

Nicholas Cain

Posted Monday, March 05, 2007 5:12 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 4:27 PM
Points: 2,007, Visits: 6,040

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

K. Brian Kelley

Posted Monday, March 05, 2007 1:06 PM

Keeper of the Duck

Group: Moderators
Last Login: Today @ 1:55 PM
Points: 6,584, Visits: 1,789

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

Nicholas Cain

Posted Monday, March 05, 2007 1:23 PM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 4:27 PM
Points: 2,007, Visits: 6,040

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 »

Permissions