You do have some disparity between estimated and actual rows, so you might have some issues with the age of your statistics. That clustered index seek on 300000 rows against...

First, a view is not going to improve performance. A view is just a query. That's all.

To improve performance you need to understand how your database is being queried. If...

Do you have a limit on the SQL Server memory setting? I'd look there first.

Second, what kind of queries are being run?

I'd be curious how you're incorporating the 3rd party tool into your native backups, assuming that's what's going on. Also, why.

When tuning queries the execution plan is a must. I know you said you have indexes, but we can't tell whether or not they're being used without the execution plan....

ravisamigo (3/24/2011)

---

Thanks.

But I have tried to keep the database in suspect mode and set the alert severity to 23 but I couldn't get any alert.

In event eveviewer, I can see...

It runs one way in the datawarehouse and one way when you call it using EXEC. Are these two different applications making the call? If so, I'd check the connection...

Elliott Berkihiser (3/23/2011)

---

Gail, Grant

Thanks.

I understand how OPENQUERY directs the processing to the remote machine, and I'll look at that.

I was curious about the situation with Views. Since...

I'm with Gail. Most of the time OPENQUERY puts the processing on the remote machine. You can get some filtering done there and then only bring back the data you...

As long as you're running this function on the column, you're guaranteed table scans: CONVERT(char(10), dbo.Notes.FollowUp, 111)

OK. but if you're still looking for an answer, can you supply some more information. Fine, you're pulling 2000 rows,...

annasql (3/23/2011)

---

Thanks, the SQL Server Agent Schedule Decoder link works.

And also when I right click the job, I can see manage schedule. But how can I export the list and...

Brandie Tarvin (3/23/2011)

---

Off-topic Self Promotion!

A-Kon 22, the biggest Anime convention in the U.S., will be throwing a launch party for The Ladies of Trade Town anthology (edited by Lee Martindale)....

It really depends on the query, the structure of the table, the indexes on the table, the number of users on the system and the queries they're running, memory and...

Depending on the query, the optimizer is blazingly fast. But, it's still not zero, I get it. Usually when you hit a limit based on how a tool behaves you...