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 |
|
Jas_The_Ace
Starting Member
15 Posts |
 Posted - 2009-08-08 : 21:10:10
|
| Please could you give me a few pointers....I have two instances of MSSQL running on the same server. One's really slow.I know this because I have copied a database from one to the other and run them side by side.The slow instance has 1-5 users on it. The fast instance has just one (me). Therefore I don't think it's a resource sharing issue.The instances are running on a file server. The fast one has the sharepoint database on it (which isn't being used). I guess it was set up when they installed sharepoint server. My NetAdministrator didn't want me to use it for production databases so he set up this new instance on a different drive, and he says it's exactly the same.I'm a novice at DBAdmin, so please tell me a few obvious things that I might have overlookedThanksJasonJason |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-08-09 : 01:00:32
|
Do both instances fight for same memory, or do both instances have MAXMEM set correctly?
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
speed optimization