Does anyone have any experience with Microsoft Identity Integration Server wrt SQL Server? The database is not that big but it seems to be using a huge amount of resources and slowing down everything else on the server. Is this normal behavior? Has anyone
else had problems having an MIIS database in a shared environment?
I don;t know about MIIS but thought this link http://www.microsoft.com/technet/pro...s/default.mspx would help to search for any information on gaining performance.
BTW what are the memory settings on SQL server?
--
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on Performance topic.
"J Jetson" wrote:
> Does anyone have any experience with Microsoft Identity Integration Server wrt SQL Server? The database is not that big but it seems to be using a huge amount of resources and slowing down everything else on the server. Is this normal behavior? Has anyo
ne else had problems having an MIIS database in a shared environment?
Showing posts with label experience. Show all posts
Showing posts with label experience. Show all posts
Monday, March 12, 2012
MIIS and SQL Server
Does anyone have any experience with Microsoft Identity Integration Server w
rt SQL Server? The database is not that big but it seems to be using a huge
amount of resources and slowing down everything else on the server. Is this
normal behavior? Has anyone
else had problems having an MIIS database in a shared environment?I don;t know about MIIS but thought this link http://www.microsoft.com/technet/pr...is/default.mspx would help to search for any information on gaini
ng performance.
BTW what are the memory settings on SQL server?
--
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on Perform
ance topic.
"J Jetson" wrote:
> Does anyone have any experience with Microsoft Identity Integration Server wrt SQL
Server? The database is not that big but it seems to be using a huge amount of reso
urces and slowing down everything else on the server. Is this normal behavior? Has a
nyo
ne else had problems having an MIIS database in a shared environment?
rt SQL Server? The database is not that big but it seems to be using a huge
amount of resources and slowing down everything else on the server. Is this
normal behavior? Has anyone
else had problems having an MIIS database in a shared environment?I don;t know about MIIS but thought this link http://www.microsoft.com/technet/pr...is/default.mspx would help to search for any information on gaini
ng performance.
BTW what are the memory settings on SQL server?
--
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on Perform
ance topic.
"J Jetson" wrote:
> Does anyone have any experience with Microsoft Identity Integration Server wrt SQL
Server? The database is not that big but it seems to be using a huge amount of reso
urces and slowing down everything else on the server. Is this normal behavior? Has a
nyo
ne else had problems having an MIIS database in a shared environment?
Migration VFP to MS SQL Server 2000
Dear Friends,
I am about to migrate a Visual FoX Pro 7.0 & 5.0 databases to MS SQL
Server 2000. I would like to
share the experience with you, if you have undergone such a task. Is
there any utility for achieving
this.
Any white paper or link for guidance on the same.
I wannted to migrate the whole database to MS SQL Server 2000. I wanted
to migrate the table
structures and procedures to MS SQL Server 2000.
Please shed some light please.
Regards
Kumar
--
Posted via http://dbforums.comFoxPro 7 includes an Upsizing Wizard that will move your schema and data
into SQLServer. I believe this wizard was also in 5.
However, I suggest you take the opportunity to redesign your database in SQL
rather than just rely on the Wizard. Your database will probably need design
changes to take best advantage of the SQL platform. When you have designed
your SQL schema you can use SQLServer DTS to help transform the data from
FoxPro to SQL.
Your code will certainly need re-writing. The syntax and behaviour of SQL
statements in FoxPro (SELECT, INSERT, UPDATE, DELETE) are quite different to
Transact-SQL. I don?t know of any tools to help with this process.
--
David Portas
--
Please reply only to the newsgroup
--|||In news:3561073.1068013648@.dbforums.com,
sgnerd <member23530@.dbforums.com> posted:
> Dear Friends,
> I am about to migrate a Visual FoX Pro 7.0 & 5.0 databases to MS SQL
Server 2000. I would like to share the experience with you, if you have
undergone such a task. Is there any utility for achieving this. Any white
paper or link for guidance on the same.
> I wannted to migrate the whole database to MS SQL Server 2000. I wanted to
migrate the table structures and procedures to MS SQL Server 2000.
Hi Kumar,
If you have Visual FoxPro available there's an Upsizing Wizard that will do
what you want. For more information try
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dgUpsizing_Visual_FoxPro_Databases.asp .
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@.mvps.org, www.cindywinegarden.com
I am about to migrate a Visual FoX Pro 7.0 & 5.0 databases to MS SQL
Server 2000. I would like to
share the experience with you, if you have undergone such a task. Is
there any utility for achieving
this.
Any white paper or link for guidance on the same.
I wannted to migrate the whole database to MS SQL Server 2000. I wanted
to migrate the table
structures and procedures to MS SQL Server 2000.
Please shed some light please.
Regards
Kumar
--
Posted via http://dbforums.comFoxPro 7 includes an Upsizing Wizard that will move your schema and data
into SQLServer. I believe this wizard was also in 5.
However, I suggest you take the opportunity to redesign your database in SQL
rather than just rely on the Wizard. Your database will probably need design
changes to take best advantage of the SQL platform. When you have designed
your SQL schema you can use SQLServer DTS to help transform the data from
FoxPro to SQL.
Your code will certainly need re-writing. The syntax and behaviour of SQL
statements in FoxPro (SELECT, INSERT, UPDATE, DELETE) are quite different to
Transact-SQL. I don?t know of any tools to help with this process.
--
David Portas
--
Please reply only to the newsgroup
--|||In news:3561073.1068013648@.dbforums.com,
sgnerd <member23530@.dbforums.com> posted:
> Dear Friends,
> I am about to migrate a Visual FoX Pro 7.0 & 5.0 databases to MS SQL
Server 2000. I would like to share the experience with you, if you have
undergone such a task. Is there any utility for achieving this. Any white
paper or link for guidance on the same.
> I wannted to migrate the whole database to MS SQL Server 2000. I wanted to
migrate the table structures and procedures to MS SQL Server 2000.
Hi Kumar,
If you have Visual FoxPro available there's an Upsizing Wizard that will do
what you want. For more information try
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dgUpsizing_Visual_FoxPro_Databases.asp .
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@.mvps.org, www.cindywinegarden.com
Wednesday, March 7, 2012
Migration from VFP to MS SQL Server 2000
Dear Friends,
I am about to migrate a Visual FoX Pro 7.0 & 5.0 databases to MS SQL
Server 2000. I would like to
share the experience with you, if you have undergone such a task. Is
there any utility for achieving
this.
Any white paper or link for guidance on the same.
I wannted to migrate the whole database to MS SQL Server 2000. I
wanted to migrate the table
structures and procedures to MS SQL Server 2000.
Please shed some light please.
Regards
KumarReplied in microsoft.public.sqlserver.server
Please don't multi-post.
--
David Portas
----
Please reply only to the newsgroup
--
Migration from PervasiveSQL 7 to SQL Server 2000(Recomendations)
*sorry for spelling mistakes - im forigne
If you have experience with this procedure please let me know of any difficulties/problems that occured because of the change over. What procedure did you go through to make them compatible and perform at a reasonable level? Do you know the appox. size increase of the database (GB/MB) from one version to the other?
Current platform:
Compaq Proliant
Netware 4.5
4.5 GB database (accounting/inventory)
New platform:
IBM eserver X235
Win 2000 SQL Server
avalible HDD space approx. 100gb
If you could make any suggestions it would be appreciated.bump
If you have experience with this procedure please let me know of any difficulties/problems that occured because of the change over. What procedure did you go through to make them compatible and perform at a reasonable level? Do you know the appox. size increase of the database (GB/MB) from one version to the other?
Current platform:
Compaq Proliant
Netware 4.5
4.5 GB database (accounting/inventory)
New platform:
IBM eserver X235
Win 2000 SQL Server
avalible HDD space approx. 100gb
If you could make any suggestions it would be appreciated.bump
Subscribe to:
Posts (Atom)