A what?

That's a hell of a lot of sessions submitted...

p.s. did you get the bribe I sent? :hehe:

First things first. Stop using sysdatabases. It's deprecated, it's included only for backward compatibility with SQL 2000, it doesn't have columns for new features and it will be removed one...

What wait types are you seeing on your data modification queries?

What do the disk latency counters look like (physical disk sec/read and physical disk sec/write)?

Compare to previous baselines.

Also, if the server isn't handling that number, you can't exactly go to the users and tell them to do less work. Rather you'd have to tune/upgrade...

What for? SQL is capable of managing its own...

tony28 (3/26/2014)

---

Guys, I understand that you dont understand why I want to do, but it looks that we have problem with disk subsystem.

It is not possible to buy new...

I've seen 10, I've seen 50000. You can't compare that number to someone else, it's about your specific workload.

That is a corruption message (and would have been useful to post initially). If however you had something like an index rebuild run between the time you got the error...

0 errors, so nothing's wrong.

Message like what?

No idea, maybe if you post the actual message that you got from CheckDB

That looks like a perfectly normal index page as dumped by DBCC Page.

Officially weird

For completeness (and because I'm stuck for ideas), can you post the results of a RESTORE FILELISTONLY on both backups, as well as the output of a SELECT *...

Compatibility level you can change up and down as you like. It makes no changes to the database, it just affects how the parser and query processor treat some T-SQL...

Please don't post multiple threads for the same question, it just wastes people's time as they have to reply in multiple places and makes things hard to follow.

Please can we...

File extension can be .isanoddextension for all SQL cares. Extensions have no effect on behaviour

Please note: 4 year old thread