Viewing 15 posts - 13,186 through 13,200 (of 22,224 total)
WayneS (2/20/2011)
@Grant, Steve, Jeff - any chance...
"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
February 20, 2011 at 4:09 pm
Hard to say, I don't know your systems or the volumes involved. I would only split to another database if I thought the load required it.
"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
February 20, 2011 at 9:10 am
To connect to that, you have to supply the machine name as well as the instance name. MachineName\SQLServer from what you showed ought to do the trick. I suspect you're...
"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
February 20, 2011 at 5:45 am
I suspect everyone has their own best practice. I only break down schemas into either discrete security areas, where I'm going to treat some tables differently than others for security,...
"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
February 20, 2011 at 5:43 am
Just a side note, if your reindex jobs don't finish and you stop them, isn't the problem just going to spiral? Won't every night it get, maybe, just a little...
"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
February 20, 2011 at 5:39 am
That's the right approach, if, your client and their business model just wants the historical aggregation information. If they want more, as you say, you're stuck. I can't tell you...
"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
February 20, 2011 at 5:36 am
Best advice I can give you is to read the documentation so you know what you're doing. It's available online here.
Do the standalone install. By and large if you accept...
"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
February 20, 2011 at 5:30 am
Craig Farrell (2/20/2011)
For anyone curious, my opinions on the SQLSaturday #47 event in Phoenix.http://www.sqlservercentral.com/Forums/Topic1066836-1199-1.aspx
All in all, a very satisfying day.
Sounds like a good event. Sorry I couldn't make that one.
"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
February 20, 2011 at 5:26 am
You're retrieving 92k out of 95k from the table. There's no real way to speed that type of data access up. You're going to get scans, and you're dependent on...
"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
February 19, 2011 at 8:58 am
mazzz (2/18/2011)
The CXPACKETs as far as I could tell were waiting on PAGEIOLATCHes. 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
February 18, 2011 at 10:54 am
What do the wait stats look like? What are the processes on the server waiting for? That'll help you determine the biggest pain points.
"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
February 18, 2011 at 9:44 am
You have to start troubleshooting the system. First, are all users on all applications on all databases suffering, or only some? That help determine where to look. Have things been...
"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
February 18, 2011 at 8:28 am
avinashily (2/18/2011)
i have a table with the following data types defined for the columns,
a nvarchar(50) not null,
nume numeric(18,0) not null,
time1 datetime null,
variab nvarchar(max) null,
abc text null,
numcha nchar(20) null,
can you...
"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
February 18, 2011 at 8:24 am
I'll also add one to the list, hash tables and work tables created as part of execution plans.
"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
February 18, 2011 at 8:18 am
I'll go Roy one step further and suggest that you have to approach the index hints with extreme caution, especially if it's adding a large list of INCLUDE columns.
It sounds...
"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
February 18, 2011 at 8:16 am
Viewing 15 posts - 13,186 through 13,200 (of 22,224 total)