Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ferretneck
Starting Member
11 Posts |
 Posted - 2011-12-20 : 09:25:06
|
| Hi allI have recently uploaded a new website (which I have been developing locally) to our dedicated Windows server.The server is a better spec than my PC and it is using the exact same SQL software to run transactions.Details:8GB RAMSQL Server 2008 ExpressExact copy (structure and data) of database - ie: no differenceSome pages accessing the database are very quickOn one particular page of the website, results are being returned 4 or 5 times slower on the server than they are on my local PC. This uses a stored procedure.It is important to note that both sites (local and server) are using the same code and database. This rules out issues with the code / stored procedure, as if it were either of these, the slowness would be apparent on both instances of the website.Are there any server settings I can look at to get to the bottom of the problem?Thanks in advanceBen |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2011-12-20 : 10:20:13
|
| Do you have any indexes or Priimary keys set up on the table locally that haven't been copied to the server. |
 |
|
|
ferretneck
Starting Member
11 Posts |
Posted - 2011-12-20 : 10:37:18
|
| No, as above: Exact copy (structure and data) of database - ie: no difference |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2011-12-20 : 10:51:50
|
| Well, you could have always got a bad plan on the server. try dbcc freeproccache. This will mean queries will take longer first time they are run after this command, but it will free up any bad plans for a query. |
|
|
|
|
|
|
Local vs Server - Slowness