Viewing 15 posts - 24,211 through 24,225 (of 49,552 total)
drew.georgopulos (8/11/2011)
@start and @enddates are collected by ccr0_BuildApproach and passed to each called sproc
exec sp_ccr2_encounter_table_ageAndsex @start_dt = @start_dt_master, @end_dt = @end_dt_master, @anchor_dt = @anchor_dt_master
then they are used in the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 11, 2011 at 3:35 pm
Add ID as a 3rd key column to this index:
CREATE NONCLUSTERED INDEX [N2] ON [dbo].table
(
field_name2 ASC,
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 11, 2011 at 3:24 pm
Please post index definitions.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 11, 2011 at 2:50 pm
See - http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 11, 2011 at 2:50 pm
If you have confirmed (not through task manager, it lies) that the memory is allocated to SQL, then it's in the non-paged area, the portion that is used for CLR,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 11, 2011 at 2:19 pm
If you have no experience at all, a cert's not necessarily going to help you.
http://www.brentozar.com/archive/2009/04/how-to-get-a-junior-dba-job-part-1/
That said, 448 is a BI exam, so what kind of jobs are you looking for?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 11, 2011 at 1:57 pm
As I've said repeatedly, it's not the queries. The buffer pool (which includes the data cache, plan cache and memory grants for queries) is limited by the server max memory...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 11, 2011 at 1:46 pm
MyDoggieJessie (8/11/2011)
Regarding how these reports get pulled from the queue: each are wrapped in it's own seprate transaction.
A transaction alone does not guarantee that the two are properly isolated. Try...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 11, 2011 at 1:45 pm
Brandie Tarvin (8/11/2011)
NJ-DBA (8/11/2011)
select a.country,a.zone,a.branch,a.user1 as 'user', b.user1 as user2from test a, test b
where a.user1='farooq'
and b.user1='jawwad'
Um, don't use this code. It's outdated, deprecated, and will disappear from SQL Server in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 11, 2011 at 1:36 pm
sjimmo (8/11/2011)
Gila
thread stack, backup buffers, CLR, in-process linked server drivers and a couple other things
Question - wouldn't these all show as an external process to windows?
No. Those are all in-process...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 11, 2011 at 1:29 pm
slanky2 (8/11/2011)
That was what I thought. Since I set the max memory to use then queries shouldn't use anymore than that.
I ran
sp_configure 'min server memory', 1024
RECONFIGURE
GO
sp_configure 'max server...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 11, 2011 at 12:43 pm
First things I'd do:
Ensure SQL's max memory is set. 58-60GB for 64GB total assuming that it's a dedicated server.
Check what other than SQL is using the memory.
Oh, and make sure...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 11, 2011 at 12:10 pm
No.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 11, 2011 at 12:07 pm
Those all check the contents of the buffer pool. SQL's max memory is set to 4GB, hence the buffer pool is limited to 4GB. The question being asked is what...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 11, 2011 at 12:06 pm
SQL should never be using the page file. If it is, something's already wrong.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 11, 2011 at 11:59 am
Viewing 15 posts - 24,211 through 24,225 (of 49,552 total)