[dba-SQLServer] SQL Performance

How much ram did you allocate to SQL Server?  If you open EM, and right click on your registered server, you will have a tab for the memory configuration, is it set to fixed, or dynamic, and if dynamic what is the maximum range?




Jim Lawrence (AccessD) wrote:

>Hi Robert:
>
>Thanks for the comments...An example of how slow we are talking about is 6.5
>minutes just to display the list of tables from Master DB. Oracle may be
>slow but not that slow...
>
>Jim
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
>Djabarov, Robert
>Sent: Tuesday, February 24, 2004 8:02 AM
>To: dba-sqlserver at databaseadvisors.com
>Subject: RE: [dba-SQLServer] SQL Performance
>
>
>You can also try to load Oracle and DB2 on it, then see who's slower :)
>
>Robert Djabarov
>SQL Server & UDB
>Sr. SQL Server Administrator
>Phone: (210)  913-3148
>Pager: (210) 753-3148
>9800 Fredericksburg Rd. San Antonio, TX  78288
>www.usaa.com
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim
>Lawrence (AccessD)
>Sent: Saturday, February 21, 2004 5:16 PM
>To: dba-sqlserver at databaseadvisors.com
>Subject: [dba-SQLServer] SQL Performance
>
>Hi All:
>
>I have just installed a new version of SQL2000 developer on one of my
>servers. The sever is not big but has reasonable performance and as I
>use it
>just for testing... It is 1700Mhz, 1GB RAM, Windows2000 advanced Server
>software. It is running a number of applications but all seem happy
>together; ASP, JSP, Perl PHP, JSP with IIS and MySQL.
>
>The recently installed MSSQL 2000 runs like a dog; so sloooooow. Nothing
>else is affected and it seems to run and run to do the simplest of
>tasks.
>
>Would anyone have some insight into what could possibly be going wrong.
>
>Any comments would be greatly appreciated.
>MTIA
>Jim
>
>  
>


-- 
-Francisco