Easy to use SQL Benchmarks?

Phal

Phal

Phal

Soldato
Joined
19 Jul 2004
Posts
4,087
Location
Shoreham by Sea
Before I start this - I know very little about SQL :P


Weve been asked to look at a server to see if theres any problems because a database upgrade is taking longer than usual.

The guy doing the upgrade says that this process normally takes 2-3hrs on his home PC but the server is taking 10hrs or so to do this conversion or upgrade.

The server itself only has 4gb of RAM and half of that is pretty much constantly used by SQL so Im sure that doesnt help. Also, I found that the SQL files werent excluded from the AV scanning so Im sure that had a hit on the performance lol. The other 2gb of RAM is used up by Exchange and other bits and bobs.

Aside from that, the server looks ok, CPU usage is low and the server responds fine when being used.



What Im looking for is an easy to use utility so I can compare performance from this SQL database to another one. It either needs to pretty much run itself or come with some half decent instructions lol.

If there isnt one then I guess we'll have to do without lol
 
Exchange AND SQL with 4gb RAM? Unless you've got sub 20 users, this sounds very underspecced. Is it SBS?
 
Yeah, its SBS 2003 and caters for around 20-25 users.

The SQL itself is probably only used by 5-10 users at the most.
 
svbooga said:
First thing would be to download the SQL 2005 performance dashboard, it gives you a series of reports to let you see what is happening on the SQL side of the server.

http://www.microsoft.com/downloads/...0d-7e0c-4730-8204-e419218c1efc&displaylang=en

SQL needs to be on SP2 before you can use them.
Click to expand...


Yeah, I found that in an old post here :p

Two problems with that, first of all the server has SQL 2000 and second of all, it seems to require some SQL knowledge lol :P

I know how to check if the SQL Server service is running and I can start the administration console but thats about it lol

We dont really do SQL support here, Im just looking for a method of testing the performance of it :\
 
I thought SBS 2003 came with SQL 2005 workgroup edition now, but if its 2000 yeah that link is no good. Anyway it doesnt require much knowledge to open a query and click run. After that its all clicky reports.
 
svbooga said:
I thought SBS 2003 came with SQL 2005 workgroup edition now, but if its 2000 yeah that link is no good. Anyway it doesnt require much knowledge to open a query and click run. After that its all clicky reports.
Click to expand...

Dont know a webby that would have a guide/walk through on doing that do you? lol
 
You must log in or register to reply here.
Back
Top Bottom