SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Citrix MetaFrame, SQL Server, and the DBA


Citrix MetaFrame, SQL Server, and the DBA

Author
Message
K. Brian Kelley
K. Brian Kelley
Keeper of the Duck
Keeper of the Duck (13K reputation)

Group: Moderators
Points: 13788 Visits: 1917
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/citrix_metaframe.asp

K. Brian Kelley
@‌kbriankelley
Nicholas Cain
Nicholas Cain
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4076 Visits: 6200
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
timscronin
timscronin
SSC Eights!
SSC Eights! (894 reputation)SSC Eights! (894 reputation)SSC Eights! (894 reputation)SSC Eights! (894 reputation)SSC Eights! (894 reputation)SSC Eights! (894 reputation)SSC Eights! (894 reputation)SSC Eights! (894 reputation)

Group: General Forum Members
Points: 894 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



Yelena Varshal
Yelena Varshal
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5702 Visits: 597

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

Nicholas Cain
Nicholas Cain
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4076 Visits: 6200
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
Paul Smith-221741
Paul Smith-221741
Mr or Mrs. 500
Mr or Mrs. 500 (548 reputation)Mr or Mrs. 500 (548 reputation)Mr or Mrs. 500 (548 reputation)Mr or Mrs. 500 (548 reputation)Mr or Mrs. 500 (548 reputation)Mr or Mrs. 500 (548 reputation)Mr or Mrs. 500 (548 reputation)Mr or Mrs. 500 (548 reputation)

Group: General Forum Members
Points: 548 Visits: 334
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.
Nicholas Cain
Nicholas Cain
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4076 Visits: 6200
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
K. Brian Kelley
K. Brian Kelley
Keeper of the Duck
Keeper of the Duck (13K reputation)

Group: Moderators
Points: 13788 Visits: 1917
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
@‌kbriankelley
Nicholas Cain
Nicholas Cain
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4076 Visits: 6200
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search