Viewing 15 posts - 16,411 through 16,425 (of 22,229 total)
No, Operations Manager is a completely seperate product from Microsoft. But it does work off of the performance monitor counters like most other monitoring products.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 2, 2009 at 9:02 am
Hmmm... Have you looked at the execution plans for the quick & the slow execution? Check the connection properties from the ORM tools to see if they're setting something differently...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 2, 2009 at 8:49 am
You can move the CSV files into a database. There, you've got all the tools you need for interpreting the data.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 2, 2009 at 8:41 am
It really depends on the number of counters you're collecting and the frequency with which you collect them. Personally, only 2 days a month wouldn't be nearly enough. We use...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 2, 2009 at 8:41 am
Alvin Ramard (10/2/2009)
Lynn Pettis (10/2/2009)
Ten thousand posts isn't that far off actually. All it takes is one hot topic to bring out a lot of posts.
One hot topic? ...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 2, 2009 at 8:11 am
Roy Ernest (10/2/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 2, 2009 at 7:50 am
As near as I can tell, it's a personal preference.
Your backup scripts are easier if they they always write to the same location. You don't have to come up with...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 2, 2009 at 7:34 am
repent_kog_is_near (10/1/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 2, 2009 at 7:30 am
Read, study and test, test, test. That's the only way to go.
Read books, the Inside SQL Server series is excellent.
Read the forums here at SSC.
Read blogs, start with Gail Shaw's...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 2, 2009 at 7:25 am
I'm willing to point you at lists of questions, sure, but studying questions & answers is no way to prepare for an interview. You either know the technology to the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 2, 2009 at 7:15 am
Lynn Pettis (10/2/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 2, 2009 at 7:07 am
rockingadmin (10/2/2009)
is there any way other than file stream in sqlserver 2008 for storing large files suchas 10gb file.
None that I'm aware of. You could create 8 or 10...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 2, 2009 at 6:27 am
What you have to do is import the data from Profiler into a table (preferably not a production server). Then you clean the ouput, basically removing parameters from the Text...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 1, 2009 at 9:55 am
peter.lane (10/1/2009)
Sorry for wasting your time. Having done the restore, I was releasing to the developers who were dropping and recreating the stored procedures and then coming to me just...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 1, 2009 at 9:40 am
You want to use filestream. It puts a sort of lock on the file to ensure database integrity. As long as the record exists in the SQL Server, the file...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 1, 2009 at 4:59 am
Viewing 15 posts - 16,411 through 16,425 (of 22,229 total)