Viewing 15 posts - 8,731 through 8,745 (of 22,214 total)
Perfmon doesn't show that type of material. You'll want to capture query metrics using a server-side trace (not Profiler, don't run the GUI against production machines) or extended events. But...
March 9, 2014 at 5:46 am
I'd go with a pre-built script to do the heavy lifting. I like Michelle Ufford's scripts[/url] for doing this. Others like Ola Hollengren's.
March 9, 2014 at 4:52 am
If we're talking SQL Server 2012, you can use a SEQUENCE. There are a number of examples on the documentation page.
March 9, 2014 at 4:51 am
If you're not using SQL Server 2000, you should be avoiding aliasing users. sp_addalias is deprecated functionality. I don't even think it's available in SQL Server 2008 or higher. Also,...
March 9, 2014 at 4:48 am
aviadavi (3/9/2014)
one more thing,How can I know (during load) if the SQL is now in bottleneck ?
You're either seeing long wait times, or blocked processes, or both. If you're seeing...
March 9, 2014 at 4:36 am
Sqlsavy (3/9/2014)
Thank you all.How frequently Index rebuild job can be run? every night or weekly?
It depends on what you can afford on your system and, how much the indexes fragment....
March 9, 2014 at 4:34 am
Best of luck. You know where to go if you need more help.
March 8, 2014 at 12:21 pm
I'd be curious why the plans are choosing to do scans. Assuming the distribution of the data hasn't changed, just having more data doesn't generally affect the statistics that much....
March 8, 2014 at 10:28 am
Maybe I don't understand the question, but you create a primary key using the add constraint command. It just so happens that any kind of unique constraint, and the primary...
March 8, 2014 at 10:18 am
MyDoggieJessie (3/7/2014)
March 8, 2014 at 4:11 am
Jack Corbett (3/7/2014)
March 8, 2014 at 4:00 am
Well, it's not really simple. The issue is, you shouldn't be seeing locks held like that. It means the system is improperly put together. Not helpful I realize, but, there...
March 7, 2014 at 12:47 pm
suneel kamavaram (3/7/2014)
This may help
So, correct me where I'm wrong, but doesn't that just address deadlocks? The situation we're in here is not deadlocks, but blocks. Totally different. Unless I'm...
March 7, 2014 at 12:28 pm
The only way you can do that is to somehow filter that out of your UPDATE query using the WHERE clause. There's nothing in the system that lets you update...
March 7, 2014 at 12:16 pm
The only reason, other than outright compatibility issues, is price.
The licensing costs for SQL Server 2012 are different than 2008R2 and less. For most situations I've seen, they're more. So,...
March 7, 2014 at 11:56 am
Viewing 15 posts - 8,731 through 8,745 (of 22,214 total)