[THIN] Re: Large Access datastore

  • From: Michael Hagberg <michael.hagberg@xxxxxx>
  • To: "'thin@xxxxxxxxxxxxx'" <thin@xxxxxxxxxxxxx>
  • Date: Thu, 5 Sep 2002 17:19:40 +0200

I agree as well, but if you use SQL2000 don't use SP2 for SQL because its
gonne mess up your IMA services.

Michael


-----Original Message-----
From: Chris Lynch [mailto:lynch00@xxxxxxx]
Sent: den 5 september 2002 17:18
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Large Access datastore



 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I copmletely agree.  If you wanted to use an Access IMA DataStore,
limit to no more than 5-10 servers.  Otherwise, use SQL2000 or
Oracle.

CHRIS LYNCH -  MCSE, CCNA, CCA
NETWORK ENGINEER - INFORMATION TECHNOLOGY
NRT Incorporated, 27271 Las Ramblas, Mission Viejo, CA 92691
Chris.lynch@xxxxxxxxxx  Tel 949.367.3406


- -----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On
Behalf Of Ron Oglesby
Sent: Thursday, September 05, 2002 7:18 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Large Access datastore



I wouldn't use access for anything more than a handful of servers.

There are also some maintenance utils you can run on the db.=20

I would back it up. Then try a DSMAINT COMPACT  to see if you can
reduce = the size at all..

If that doesn't help its time to migrate to SQL

Ron Oglesby
Senior Technical Architect
=20
RapidApp
Office 312.372.7188
Mobile 312.961.2380
email roglesby@xxxxxxxxxxxx
=20

- -----Original Message-----
From: Anders Hansen-=D8vre [mailto:anders.hansen-ovre@xxxxxxxxx]=20
Sent: Thursday, September 05, 2002 9:16 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Large Access datastore


We have 27 terminalservers, all running XPe with IM and RM.

The mf20.mdb is now almost 200mb and the CMC are not working as it
=3D should. When started the console timeout and don't display all
the tab = =3D and so on.

Faq:
Windows 2000
XPe SP/FR2

Anyone seen this before ?

- ---
mvh/yours
Anders Hansen-=3DD8vre, Seniorkonsulent=3D20
Mail    : anders.hansen-ovre@xxxxxxxxx
Mail    : anders.hansen-ovre@xxxxxxxxxxxxxxxxx
Cell    : (+47) 90 98 17 78

Konsulenthuset Contra as
Hedmark N=3DE6ringspark, Bygg 15, 2312 Ottestad
Phone   : (+47) 62 54 42 99
Fax     : (+47) 62 54 42 85
Mail    : post@xxxxxxxxx
Web     : http://www.contra.no=3D20


**********************************************
This weeks sponsor 99Point9.com
99Point9 helps solve your unresolved technical
server-based questions, issues and incidents. http://www.99point9.com
***********************************************

For Archives, to Unsubscribe, Subscribe or=20
set Digest or Vacation mode use the below link.

http://thethin.net/citrixlist.cfm


**********************************************
This weeks sponsor 99Point9.com
99Point9 helps solve your unresolved technical
server-based questions, issues and incidents. http://www.99point9.com
***********************************************

For Archives, to Unsubscribe, Subscribe or 
set Digest or Vacation mode use the below link.

http://thethin.net/citrixlist.cfm

-----BEGIN PGP SIGNATURE-----
Version: PGP 7.1

iQA/AwUBPXd1w/l56xfvzmMfEQLZmgCg3trYkyWBHfwSZnaGiti8Zv+sMJ0AnR/W
BcLvNQXy+7XAaccO16w7XF1H
=tgL9
-----END PGP SIGNATURE-----



**********************************************
This weeks sponsor 99Point9.com
99Point9 helps solve your unresolved technical
server-based questions, issues and incidents.
http://www.99point9.com
***********************************************

For Archives, to Unsubscribe, Subscribe or 
set Digest or Vacation mode use the below link.

http://thethin.net/citrixlist.cfm


**********************************************
This weeks sponsor 99Point9.com
99Point9 helps solve your unresolved technical
server-based questions, issues and incidents.
http://www.99point9.com
***********************************************

For Archives, to Unsubscribe, Subscribe or 
set Digest or Vacation mode use the below link.

http://thethin.net/citrixlist.cfm

Other related posts: