I have couple of SQL Tables with customers information the database works fine on SQL server 2005 but when doing a search when the tables are under SQL 2008 R2 SP2 it runs really slow example I type couple of letters in the search field seems to take its time to input what I have typed like really bad lag
anyone got any ideas please.
Hello and welcome to the forums. You aren't giving us much to go on here. We can't see what's on your screen, so we don't know anything about what you're using or encountering other than what you post. Here's a few questions to get started:
1. What search field are you typing into? Is this an application you've written?
2. How's the performance of the query in in SSMS? That will eliminate any extra variables and narrow the execution down to the database.
3. How did the tables and data get from 2005 to 2008? If the indexes aren't there in 2008, that will cause performance problems.
4. Can you quantify "like really bad lag"?
In order to troubleshoot a query, we'll need some readily-consumable DDL, data, expected results and what you've tried so far. Please see the link in my signature for advice on how to post questions to the forum.
Tally Tables - Performance PersonifiedString Splitting with True PerformanceBest practices on how to ask questions