Upgrading MY Preformance

Jul 20, 2005

Hello all! I'm a newly appointed database administrator and have been
struggling with my consious about what would make me an excellent
database administrator. I've worked in Access for years and know that
if your comfortable with:
1. writing expressions
2. writing some VBA
3. the basics with Tables, Forms, Queries and Reports.

and you'd be sitting pretty. SQL Server is a little more robust than
Access and i'm not sure where I should start.

I'm comfortable with writing T-SQL statments, backing up, and creating
users. but other than that, i'm a little lost on what else i should
know.

thanks.

View 1 Replies


ADVERTISEMENT

Preformance And Hardware Needs

Mar 6, 2001

Does anyone have any formulas or standards that you use in determining the hardware needs of either a new server or for keeping your current server in top running condition.

Also, I know some of the basics for performance on the databases, but any ideas on things I should look for (or documentation links) on utilizing the best performance of the server itself?

thanks in advance for any comments

View 2 Replies View Related

SQL ServerAgent Preformance Degridation

Dec 22, 1999

I have found a huge prefomance degridation running something thru a Job on the server and running it through ISQL.

I have a sp the runs in about 24 min thru ISQL, but when I fire it off thru a job at night using the Agent, it take roughly 4.5 hours... Way slow...

Any thoughts?

View 1 Replies View Related

Sequence Of Columns And Preformance

Jul 6, 2006

Hello,I am learning SQL Server and I would like to ask you a question. Couldyou tell me please if sequence of columns in a table has influence onperformance?Thank you very much/RAM/

View 3 Replies View Related

Need To Know The Preformance Statistics Of SSIS!

Nov 6, 2007

Hi All,

Need to know the preformance statistics of SSIS!

Please reply Ur comments,

Regards,
Sandesh

View 3 Replies View Related

Poor Preformance Usinng Sql 2005 With Access 2003 Application

Jan 1, 2007

we have run access 2003 application using SQL 2005 server
and the data transfer rate is extreamly slow.
we are using ODBC connection
and the access apllication works very fast with SQL 2000.

we have the tested the comptabilty of the application to SQL 2005 with Microsoft wizard and it had no problems.
even when i run simple application on the sql 2005 server, it runs very slowly.

i am using the MDAC clients ODBC component and the SQL Native Clients one.
which eliminates the possibilty of network problem.

what could be the problem???

View 1 Replies View Related

Upgrading To Sql 7.0

Feb 5, 2002

Hi,

I have to upgrade the sql server from 6.5 to 7.0 for the first time. I have decided to go with two machine upgrade using named pipes.

The question is: Can we still use 6.5 machine and database as production version until we test out the application on 7.0?

We are planning to relpeat the upgrade once the testing is done on 7.0 server once the testing is done.

View 1 Replies View Related

Upgrading From 6.5 To 7.0

May 14, 1999

We're going to be upgrading our Server from 6.5 to 7.0. In addition we're getting a new SQL Server Box.

Which of the following is better: a) Install SQL 6.5 on the new box, restore the DB from old box to the new box, then install 7.0 on the new box and use the upgrade wizard to upsize the DB. (We'll have room to leave the 6.5 devices on the box after upgrading.) or b) Install SQL 7.0 on the new box and upsize the db across the network (100megabit network cards).

Thanks,

Kevin M. Tupper
EZLinks Golf, Inc.
http://www.ezlinksgolf.com

View 3 Replies View Related

Upgrading 6.0 To 6.5

Jan 19, 1999

I'm following a white paper and have run chkupg65 and am stuck at resolving keyword conflicts. I see many TechNet references about fixing them...but none about how. A little help? Below are the conflicts:
Keyword conflicts
Column name: SyncModification.ACTION[SQL-92 keyword]
Column name: Jobs.EXPIREDATE[SQL-92 keyword]
Column name: SqlStoreTable.SIZE[SQL-92 keyword]
Column name: JobDetails.TIME[SQL-92 keyword]
Column name: SchedulerSafeDelete.TIME[SQL-92 keyword]
Column name: SMSEvent.TIME[SQL-92 keyword]
Column name: SyncModification.TIME[SQL-92 keyword]
Column name: vJobDetails.TIME[SQL-92 keyword]
Column name: vSMSEvent.TIME[SQL-92 keyword]
Column name: Sites.TIMESTAMP[SQL-92 keyword]
Column name: QueryExpressions.VALUE[SQL-92 keyword]

View 1 Replies View Related

Upgrading 6.5 To 2k

Jun 15, 2001

Does anyone know of a good book or resource on what's the best way to upgrade 6.5 to 2k? Or generally how would you do that considering you need to do on more then 50 servers?

View 1 Replies View Related

Upgrading 2k5 To Sp2

May 15, 2008

So I'm using Visual Studio's one click deployment to install/update software for users. SQL Express 2005 is the default, and I need to get all current and new users to update to SQL Express 2005 SP2. Ontop of that, I need to change the sa password for all current users (I should be able to manually set it for the new guys).

The problem I'm having is that instead of just updating the current SQL Express engine installed, it creates a new instance of the SQL Express engine when installing SQL Express SP2.

Is there anyway to just update SQL Express to SP2? Is there an easy way to change the sa password when doing so?

View 1 Replies View Related

Upgrading From 3.23 To 4.1

Jul 23, 2005

I have an application which installs MySQL 3.23. It's hard-coded. Irealize there are newer versions, so I am thinking, what's easiest:1) install the application with its default 3.23 and then run a scriptto convert 3.23 to 4.1 or later,or2) modify the application to install a newer version of MySQL from thestart.

View 2 Replies View Related

Upgrading From MDB

Nov 29, 2007

I'm in the process of upgrading a gazillion apps from using .MDB files to using SQLCE 3.5. (Or, at least planning the upgrade). Is there an easy way to save existing .MDB files as .SDFs? Also, we have an occasional app that's web based (eg. certification exam, where we have 10 people take it online at the same time, in one day, and the database keeps the score, questions, etc.); is it a good idea to move that kind of app to SQLCE from MDB?

View 3 Replies View Related

Upgrading To SP2

May 29, 2008



Hey,
I have a SQL Server 2005 Express Edition installed, and I want to upgrade to SP2.
Is there a way to configure (using the setup ini file maybe?) the installer to install only the SP2?

Thanks ahead

--sternr

View 7 Replies View Related

SP3 && SP4 Not Upgrading

Dec 22, 2005

When I run SP3 & SP4 for SQL Server it runs okay.  I get no errors after the installation & both installations call for a reboot which I do with no problems.

But yet when I get back into my machine, go to the Query Analyzer & run "Select @@version" and execute it, it's still showing v8.00.194 (Original release).  It should be showing 8.00.2039.

 

Any ideas or suggestions?

 

Thanks!

View 1 Replies View Related

Why The Data Are Different After Upgrading From 6.5 To 7.0

Apr 29, 2002

We are upgrading our servers from 6.5 to 7.0 SQL servers. I used the same configurations on both 6.5 server and 7.0 server like ANSI and the others. But SQL7.0 server turns out to have different data on some tables. Here is the example on one table. Why?

6.5 database

WT_PAY_PERIOD_DATE WT_RDC_HOURS WT_RDC_EXPENSE WT_MS_SUB_HOURS
------------------ ------------ -------------- ---------------
Apr 20 2002 12:00AM 0.00 0.00 0.00


WT_MS_APPR_IND WT_NEW_EMPL_FLAG WT_ASSOC_OTH_EXPENSE WT_ASSOC_TOT_EXP
-------------- ---------------- -------------------- ----------------
N 3.76 135.21

WT_MS_TOT_EXP WT_MS_MILE_LIM
------------- --------------
135.21 0

7.0 database

WT_PAY_PERIOD_DATE WT_RDC_HOURS WT_RDC_EXPENSE WT_MS_SUB_HOURS
----------------------- ------------ -------------- ---------------
2002-04-20 00:00:00.000 23.50 135.2050 23.50


WT_MS_APPR_IND WT_NEW_EMPL_FLAG WT_ASSOC_OTH_EXPENSE WT_ASSOC_TOT_EXP
-------------- ---------------- -------------------- ----------------
Y X 3.7600 135.2050

WT_MS_TOT_EXP WT_MS_MILE_LIM
------------- --------------
135.2050 373








------------ 135.21 135.21 0

7.0 databases

WT_PAY_PERIOD_DATE WT_RDC_HOURS WT_RDC_EXPENSE WT_MS_SUB_HOURS WT_MS_APPR_IND WT_NEW_EMPL_FLAG
------------------------------------- -------------------------- --------------------------------- -------------------------------- ----------------------------- --------------------------------
2002-04-20 00:00:00.000 23.50 135.2050 23.50 Y X

WT_ASSOC_OTH_EXPENSE WT_ASSOC_TOT_EXP WT_MS_TOT_EXP WT_MS_MILE_LIM
------------------------------------------- ----------------------------------- -------------------------- ---------------------------
3.7600 135.2050 135.2050 373
************************************************** ************************************************** ************************************************** **********************
I have checked the datatypes that are transferred from SQL6.5. They are the same types as SQL6.5. Plus the configurations are the same on both 6.5 and 7.0. The question is that why the values are different? What the way is to fix it?

View 1 Replies View Related

Errors When When Upgrading To SQL 7 Sp3

Apr 30, 2002

Hi,

Well there's always a first for everything!! I have a SQL 7.0 server on sP1
and ran upgrade to sp3 and recieved error 'error in upgrade script' retry or cancel. When I retried the upgrade ended. I tried to run the upgrade again and it tries continue where it ended before, but the upgrade ends unsucessfully. I even tried extracted the sp3 exe to a diffrent folder and ran the sp3 upgrade with same results.

I started the MSSQL service ok but not able to use Query Analyzer, DTS, EM.

Get the following message:ISQL.EXE - Entry Point not found. The procedure entry point?DeleteRow@CDataCTLStorage@@UAEJJPAPAG@Z could not be located in the dynamic link library SQLGUI.dll

I get similar msgs when trying to open DTS, Enterprise manager from the server. The user databases and appear to be ok. I am able to get to Query Analyzer, etc. from my worksation fine.

Has anyone encountered this before? Is there a fix for it or do I need to rebuild the server from SP1 and restore the databases, etc.??

Thanks Much,
Steve Bajada
Senior DBA

View 3 Replies View Related

Upgrading From Sql 7 To 2000

Jul 18, 2001

Has anyone attempted an upgrade from sql7 to 2000? is it a difficult process? what happens to the users. Is there a good site i can go to to get this info ?

Thanks in advance

View 1 Replies View Related

Upgrading The Sql Server Dsn

Aug 5, 2001

Does anyone know how to upgrade a sql driver. Or where to get the driver dll from. The client machine is running 3.70.06.23 and needs 3.70.08.20 to connect to the sql server!

View 1 Replies View Related

Problem Upgrading To SQL 7.0

Aug 11, 1999

One of my students' company is doing an upgrade from SQL 6.5 to SQL 7.0
and everything converts fine except one veiw. Does anyone know what
would cause this to happen? If they run the script in SQL 7.0 it works
fine. Any thoughts?

CREATE VIEW dbo.vewRptWooActiveList
AS
SELECT vewRptWooActiveListSub1.wotUserValue1,
vewRptWooActiveListSub1.wooNum,
vewRptWooActiveListSub1.wooCreatedWhen,
vewRptWooActiveListSub1.wooDispatchedWhen,
vewRptWooActiveListSub2.MaxOfwslInsertedWhen AS wooLastStatusWhen,
vewRptWooActiveListSub1.wosUserValue1,
vewRptWooActiveListSub1.sitName,
vewRptWooActiveListSub1.empFullName_Cp,
vewRptWooActiveListSub1.Company,
vewRptWooActiveListSub1.Region,
vewRptWooActiveListSub1.ServiceCenter,
vewRptWooActiveListSub1.Zone
FROM vewRptWooActiveListSub1 INNER JOIN
vewRptWooActiveListSub2 ON
vewRptWooActiveListSub1.wooID = vewRptWooActiveListSub2.wsl_WooIDFk

Thanks
Dawn Gill

View 2 Replies View Related

Codepages When Upgrading From 6.5 To 7.0

Jul 21, 1999

I have a couple of 6.5 installations with different codepages/sort orders, when I come to upgrade these databases, is it possible to change the code pages/sort order during the upgrade of my existing databases so that I have the same sort order/codepages across all my sites?

The databases don't actually have any extended characters in.

Thanks
Dan

View 1 Replies View Related

Upgrading From SQL Server 6.0

Jul 29, 1998

All the documentation I have read talks about upgrading from SQL Server 6.x. I presume I can use the upgrade wizard to upgrade my 6.0 system directly to 7.0 without having to upgrade to 6.5 first.

Any thoughts, comments or help would be much appreciated.

View 4 Replies View Related

Upgrading From SQL6.5 To 7.0

Dec 7, 1998

Hi all :

Does the upgrade wizard in 7.0 help me upgrade ALL the database objects in SQL 6.5 (including stored procedures, triggers) to 7.0? Has anyone encountered any problems?

Rnathan

View 1 Replies View Related

Upgrading From 7.0 To 2000

Feb 13, 2002

Anyone know of any issues I should be aware of when upgrading from sql 7.0 to 2000? Is it a problematic proccess?

liz

View 2 Replies View Related

Upgrading SQL 6.5 To 7.0 Problem.

Jun 29, 2001

Have you ever faced a problem like this. I am running MS SQL Server 6.5 on Windows NT 4.0 computer whose name is with dashes (hou-is). Now, I try to update to version 7.0 and it gives me error message: @@nameserver from export 6.5 is not valid. Use sp_addserver and sp_netname.
How you can change a sql server name to non-dash name in order to complete the upgrade sql server?
I know this is a challenging tech question.
I appreciate your tech expertise.

Vinh Nguyen from Houston, TX.

View 2 Replies View Related

Upgrading To SQL 2000

Apr 19, 2002

We are currently still running SQL6.0 on NT4 server, and we want to upgrade to SQL2000. My question: how easy is it to upgrade from SQL6.0 to SQL2000?

View 3 Replies View Related

Upgrading SQL 7 To SQL 2000

Nov 2, 2001

Currently running SQL Server 7, and have databases. I want to upgrade to SQL Server 2000. How can achieve it without delete or losing my databases. This is NOT a production server, BUT I still want to keep my databases. Ideally I would like to uninstall and reinstall so that there are no SQL Server 7 files lying around when I have SQL 2000 running. Thanks.

View 1 Replies View Related

Upgrading V7.0 To 2000

Dec 3, 2004

Hi,

We are trying to upgrade from SQL Server v7.0 to SQL Server 2000. Here's our set up,

Current Server: Win NT, SQL Server v7.0
New Server : Win 2000, SQL Server 2000
Client (my PC): Win XP, SQL Server 2000

The New Server is designated SQL Server machine -- company-wide. That is, all the apps/projects uses this machine as the SQL Server. It only has one instance of SQL Server running.

Different project are assigned a dedicated 'Drive' (logical only) and allocated certain disk size as the work space. We (my team) will be the new entry for this server.

Q: When doing the Copy Wizard (from my PC) to upgrade/copy the existing v7.0 db (from Current Server) to New SQL Server 2000, do I need to specify the physicall 'Data' folder? Or, can I copy the database to the selected path -- which is my dedicated drive?

Thanks in Advance.

_msd_

View 1 Replies View Related

Upgrading Database

Jan 6, 2005

Hey,

Does anyone know how I would go about upgrading a database version to 'C.0.6.43'? I am getting an error and it is telling me to upgrade my database to this version.

Thanks

View 2 Replies View Related

Upgrading Server...

Feb 11, 2004

Hi All,

We're about to upgrade/re-build our SQL server box.

We have 2 apps which use the server (both fairly small), one uses NT security - the other uses SQL security.

My question is, apart from our 2 databases, what else should we backup (and restore onto the new clean machine) so as to preserve the user logins for the app that uses SQL security (the other one's dead simple)? The app itself maintains the user details and creates the SQL logins (with passwords etc.) but I can't find a way to 're-create' them.

Any help would be greatly appreciated.

Thanks,

John

View 1 Replies View Related

Upgrading From Access

Mar 11, 2004

I have read a few books on SQL Server and on access. I recently got my 1st programming job (vb.net)

I want to move my database from Access to SQL server. But I would like to Use access as the front end for simple data entry, queries and reports. I dont know how to do this,, (using Access as a front end for SQL Server)

Can anyone recomend topics of interest or a good book?


Thanks



~M

View 6 Replies View Related

Upgrading To 2005

Mar 5, 2007

Hi all, I'm hoping someone can help me out. I'm totally new to SQL server.

I wanted to upgrade this one server that was running SQL 8.0. I did an install of SQL2005 (9.0 right?) and it appeared to go well. But once it was completed I found out that the original installation of SQL was on a different drive. So instead of upgrading, I actually installed another instance of SQL? (Is that term correct?) So now when I open SQL2005, it shows the server name but with (SQL Server 8.0.2039) next to it.

How can I now upgrade the databases themselves?

Please help!
thanks!
-tim

View 1 Replies View Related

Moving A Db And Upgrading

Sep 11, 2007

Hi
Im new to this forum so go easy!
Ive been asked to do a few things:
1. copy an existing 2005 express db to another machine
2. on the new machine install 2005 express and get the db working
3. upgrade 2005 express to 2005 standard (have disks etc)

So far i've physically copied the .mdf and the .ldf to the new local machine and I think ive installed sql 2005 express ok, but what do I do when I start it up, eg asks for a server name etc. Is that my local machine name, ive tried browsing and cant seem to do so locally to pick up the copied db. Once ive got this sorted, is the upgrade to standard a straight forward microsoft install, or do i have to do anything to the db (unmount is it called?)

Any help/suggestions would be greatly appreciated! Many thanks

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved