homepage Welcome to WebmasterWorld Guest from 54.166.128.254
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
SQL Server 2005: Studio Express
Seems quite slow (from time to time)
giggle

10+ Year Member



 
Msg#: 4143894 posted 12:14 pm on May 30, 2010 (gmt 0)

Hi

We recently moved our website to a new dedicated server that has SQL Server 2005: Studio Express.

We get about 700 unique visitors per day and we also work the customers on the same database via the web.

From time to time the database slows waaay down and it can take 30 seconds to save a customers record. (via ASP code).

Is this version of SQL server recognised as being slow? If so, is there a more powerful version that we should employ to handle our database requirements?

I'm at a loss here as to what to do and any help would be gratefully received.

 

whoisgregg

WebmasterWorld Senior Member whoisgregg us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 4143894 posted 9:27 pm on Jun 1, 2010 (gmt 0)

Are you on shared hosting or do you have your own box or VPS?

LifeinAsia

WebmasterWorld Administrator lifeinasia us a WebmasterWorld Top Contributor of All Time 5+ Year Member



 
Msg#: 4143894 posted 9:46 pm on Jun 1, 2010 (gmt 0)

We recently moved our website to a new dedicated server that has SQL Server 2005: Studio Express.

SQL Server 2005 Express is a version of SQL Server. Microsoft SQL Server Management Studio Express is a client utility used to manage SQL Server 2005 (not sure if it can only manage SQL Server Express or the other versions of SQL Server 2005 as well).

SQL Server Express has numerous limitations, most notably in DB size and memory usage. What is the size of your database? What were you using before for your database?

whoisgregg

WebmasterWorld Senior Member whoisgregg us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 4143894 posted 11:12 pm on Jun 1, 2010 (gmt 0)

Sheesh, I need more caffeine or sleep. Or both.

Raza



 
Msg#: 4143894 posted 7:15 pm on Jun 2, 2010 (gmt 0)

I would guess the Express limitation that would be of most concern is the limit of one CPU (others are 1GB RAM for the pool and 4GB for the database size). If that CPU is shared by other processes (like IIS) and gets taxed by that other process, I can envision poor performance.

Even so, 700 visitors a day is pretty low volume. One of the unfortunate limitations of Express is that it doesn't come with Profiler, although you can run traces and import/analyze them. Normally, all things being equal, that's what I'd do to try to isolate the problem.

data recovery



 
Msg#: 4143894 posted 9:47 am on Jul 10, 2010 (gmt 0)

Hey,
I go through your post. I want to express some words. Microsoft SQL server 2005 that helps user to manages databases and all the objects on the server. It provides graphical user interface, easy to access without any technical skill required. It easily runs on Windows operating system.

Thanks

[edited by: tedster at 4:00 pm (utc) on Jul 10, 2010]
[edit reason] No URLs in signatures here, please [/edit]

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved