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 |
|
idrivediesel2006
Starting Member
2 Posts |
 Posted - 2008-11-26 : 14:10:53
|
| Config Mach_1 - Demo MachineSingle MachineMulti-Processors8GB MemoryServices Run on Domain AccountSAN Storage for data, logs, Full Text SearchConfig Mach_2 - Production (Cluster 2 Active Nodes)Multiple MachinesEach Machine w/8 Processors8 GB RAMSAN Storage same as Mach_1Services run on domain accountSearches and deletes are slow as molassas when performed on Mach_2 (production). We backup the database on Mach_2 (production) and restore it onto Mach_1 (demo) and things run fast as lightening on Mach_1 (demo).We suspect something with Full-Text Search but we're not sure. Any idea where we can begin troubleshooting on this performance issue?Thanks in advance for your help. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-26 : 20:09:09
|
| Maybe due to fact that there is not too much load in Mach_1. Did you run Performance monitor? |
 |
|
|
idrivediesel2006
Starting Member
2 Posts |
Posted - 2008-12-01 : 11:06:35
|
| We did run the SQL Profiler and narrowed down the performance to one particular stored procedure. We check the execution plan on that one stored procedure but it didn't result in a whole lot of information.We were hoping to find a missing index or something that would lead us in the right direction to fix it but no avail.I suppose we can check that same query with the PerfMon Tool. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-01 : 22:02:26
|
| You can use DMV sys.dm_missing_index_details to find missing index if any . |
|
|
|
|
|
|
Fast DB on Mach_1 but slow on Mach_2