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
Hello all! I'm a newly appointed database administrator and have beenstruggling with my consious about what would make me an excellentdatabase administrator. I've worked in Access for years and know thatif your comfortable with:1. writing expressions2. writing some VBA3. the basics with Tables, Forms, Queries and Reports.and you'd be sitting pretty. SQL Server is a little more robust thanAccess and i'm not sure where I should start.I'm comfortable with writing T-SQL statments, backing up, and creatingusers. but other than that, i'm a little lost on what else i shouldknow.thanks.
View 1 Replies View RelatedI 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?
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 RelatedHi All,
Need to know the preformance statistics of SSIS!
Please reply Ur comments,
Regards,
Sandesh
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???