Implicit queries: enterprise

Showing posts with label enterprise. Show all posts

Friday, March 30, 2012

Import Performance file Run Command

I have Windows 2000 Advanced Server with SQL Server 2000
Enterprise with SP3A. I trying to set up a job to import
Performance Monitors daily into SQL Server table. How
would I set up Performance Monitor to stop at 7AM close
the present file, create a new file at 7:02AM start
collecting statistics. Then I will DTS file into a SQL
Server table.
My performance monitor job name is SAVE_STATISTICS what
run command should I use to start my SAVE_STATISTICS at 7
AM and stop it daily 7:02 AM?
This would be a very help to resolve this issue.
Thank You,
Danyou could potentially use LOGMAN native command from a remote XP and Windows
2003 computer to Start and Stop the logs at the specified time each day - ie
a Daily scheduled task (Control Panel/ Scheduled Tasks) to do it.
And then as part of the definition of the Perfmon Log / Schedule add the
"Run this command" to have a batch file that calls DTSRUN and executes your
DTS package to import the Data.
a bit messy I admit
regards
Andy.
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:26ad201c461ce$4a260760$a301280a@.phx.gbl...
>
> I have Windows 2000 Advanced Server with SQL Server 2000
> Enterprise with SP3A. I trying to set up a job to import
> Performance Monitors daily into SQL Server table. How
> would I set up Performance Monitor to stop at 7AM close
> the present file, create a new file at 7:02AM start
> collecting statistics. Then I will DTS file into a SQL
> Server table.
> My performance monitor job name is SAVE_STATISTICS what
> run command should I use to start my SAVE_STATISTICS at 7
> AM and stop it daily 7:02 AM?
> This would be a very help to resolve this issue.
> Thank You,
> Dan
>|||Hi
I replied to you previous post on this subject! Perfmon has it's own method
of scheduling, through the Scheduling tab on the Properties dialog. You can
tell perfmon to stop the performance monitor and start a new log after a
given period. You can also specify that it runs a command when this happens.
This could be your DTS job. To change the name of the input file check out:
http://www.sqldts.com/default.aspx?200
John
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:26ad201c461ce$4a260760$a301280a@.phx.gbl...
>
> I have Windows 2000 Advanced Server with SQL Server 2000
> Enterprise with SP3A. I trying to set up a job to import
> Performance Monitors daily into SQL Server table. How
> would I set up Performance Monitor to stop at 7AM close
> the present file, create a new file at 7:02AM start
> collecting statistics. Then I will DTS file into a SQL
> Server table.
> My performance monitor job name is SAVE_STATISTICS what
> run command should I use to start my SAVE_STATISTICS at 7
> AM and stop it daily 7:02 AM?
> This would be a very help to resolve this issue.
> Thank You,
> Dan
>

Import Performance file into SQL Server table

Wednesday, March 28, 2012

import mysql dump file in sql server

does anyone have a good idea how i can easily import a mysql dump file in a
sql server 2000 enterprise edition
The dump file is 7 gig big however my MS SQL server is a DELL poweredge 4600
with 2 x 2.8 GHZ hyperthreaded XEON processors 800 gig harddisk space
and 6 gig of memory ( running on Windows 2000 advanced with PAE and AWE
extensions enabled )
hope someone has experience with this
Michel Posseth [MCP ]M. Posseth wrote:
> does anyone have a good idea how i can easily import a mysql dump
> file in a sql server 2000 enterprise edition
> The dump file is 7 gig big however my MS SQL server is a DELL
> poweredge 4600 with 2 x 2.8 GHZ hyperthreaded XEON processors
> 800 gig harddisk space and 6 gig of memory ( running on Windows 2000
> advanced with PAE and AWE extensions enabled )
> hope someone has experience with this
> Michel Posseth [MCP ]
I don't know what a dump file is, but if it's just extracted data from a
MySQL table, you can use the DTS Import/Export Wizard to import the
results into SQL Server.
David Gugick
Imceda Software
www.imceda.com|||MySQL dump file is proprietary and SQLServer wouldn't know what to do with
it. You will need to load the dump file into a MySQL somewhere and then
follow this whitepaper to transfer your data.
http://www.microsoft.com/technet/pr...ploy/mysql.mspx
-oj
"M. Posseth" <michelp@.nohausystems.nl> wrote in message
news:ctr4r3$di0$1@.reader13.wxs.nl...
> does anyone have a good idea how i can easily import a mysql dump file in
> a
> sql server 2000 enterprise edition
> The dump file is 7 gig big however my MS SQL server is a DELL poweredge
> 4600
> with 2 x 2.8 GHZ hyperthreaded XEON processors 800 gig harddisk space
> and 6 gig of memory ( running on Windows 2000 advanced with PAE and AWE
> extensions enabled )
> hope someone has experience with this
> Michel Posseth [MCP ]
>|||David Gugick wrote:
> M. Posseth wrote:
>
>
> I don't know what a dump file is, but if it's just extracted data from a
> MySQL table, you can use the DTS Import/Export Wizard to import the
> results into SQL Server.
>
a sql dump file is just a SQL script with DDL and data ( the same as
you can make in SQL server ) however with its own SQL dialect
so instead that it contains data from one table it contains all data
from a database
i know that it is possible to import the sql dump after changing the
dialect parameters to the corresponding mssql dialect
however we are talking about a 7 gig SQL text file
so i was just wondering if someone knows how i can unleash the power of
my MSSQL server on this mysql dump file so i can import it.
well i guess i am pioneering again ,
how the #$#$$% am i gonna loop through a 7 gig text file and find and
replace the mysql datatypes for the corresponding MSSQL datatypes .......
Michelsql

import logins.

can i import logins from one server to the next using the enterprise manager?you can use transfer login task from DTS.
Thanks
Chinna
>--Original Message--
>can i import logins from one server to the next using the
enterprise manager?
>.
>|||There is information on microsoft web site re: transferring logins
between servers.
"Vincent Jones" <vncntj@.hotmail.com> wrote in message
news:ba2a2d30.0308140700.517083d0@.posting.google.com...
> can i import logins from one server to the next using the enterprise
manager?|||Take a look at this article
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server ID:
246133.KB.EN-US
http://support.microsoft.com/?id=246133
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.sql

Friday, February 24, 2012

import a large table

Hi,
I am importing a large table to a table. The table contains
27 millions rows with 1 or 2 index.
I used Enterprise Manager to do the table import. I see
the "status: 275" on the import screen after 27 millions
rows are inserted. The "status: 275" is on the screen
for 4 hours already. I used "simple" option for the
recovery.
Does import should take more than 10 hours for a 27
millons rows ?
Is there a way which I can use to make import faster,
e.g. command line import option ?
Thanks in advance.
MingTry using bcp to export the data to a file and import from
the file. Use the native format (/N).
Also set batch size.
Create the indexes after the import.
>--Original Message--
>Hi,
>I am importing a large table to a table. The table
contains
>27 millions rows with 1 or 2 index.
>I used Enterprise Manager to do the table import. I see
>the "status: 275" on the import screen after 27 millions
>rows are inserted. The "status: 275" is on the screen
>for 4 hours already. I used "simple" option for the
>recovery.
>Does import should take more than 10 hours for a 27
>millons rows ?
>Is there a way which I can use to make import faster,
>e.g. command line import option ?
>Thanks in advance.
>Ming
>.
>