Integrated Security: regarding

Showing posts with label regarding. Show all posts

Friday, March 30, 2012

Internal Error / internal catalog exception

Hi,

I've read already every thread in this forum regarding this topic with no results.

SQLServer and the corresponding services are at actual update level. The reporting services worked for 4 months without this problem. Suddenly, most of the time all reports return an internal error (it is like 70-30 for internal error) not depending which render format is used.

The system logs (eventlog, iis) show no errors. The ExecutionLog of RS show rsInternalError.

Looking in the log files in RS log directory, there is following stacktrace:

w3wp!processing!1!05/11/2007-10:40:06:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

I don't see any hint in stack trace, Maybe one of yours.

As it seems, after an iisreset the first rendering always works perfect. HD space is enough.

Any ideas?

Got it.

As the error occured not every time and not depending any actions or rules, we decided to check the hardware and their corresponding drivers.

For the AMD Opteron single core processors in a multi processor environment, we used the generic microsoft drivers. After changing these to the original AMD ones, it works perfectly again.

Why it occured suddenly without any update or reboot is still not solved, but it works now.

Greez

Internal Error / internal catalog exception

Hi,

I've read already every thread in this forum regarding this topic with no results.

The system logs (eventlog, iis) show no errors. The ExecutionLog of RS show rsInternalError.

Looking in the log files in RS log directory, there is following stacktrace:

I don't see any hint in stack trace, Maybe one of yours.

As it seems, after an iisreset the first rendering always works perfect. HD space is enough.

Any ideas?

Got it.

As the error occured not every time and not depending any actions or rules, we decided to check the hardware and their corresponding drivers.

For the AMD Opteron single core processors in a multi processor environment, we used the generic microsoft drivers. After changing these to the original AMD ones, it works perfectly again.

Why it occured suddenly without any update or reboot is still not solved, but it works now.

Greez

Friday, March 9, 2012

Intel Hyper Threading

Hi
Has anyone had any SQL performance issues when Hyper Threading is enabled on
BIOS? Do you have any comments regarding to HT?
I know this is a bit of a grey area for Citrix - but i have not seen any
comments about this for SQL
Regards
James
On our SQL boxes, we keep HT enabled and tweak the SQL Server max degree of
parallelism config option to specify no more than the number of processor
cores.
Every application is different so, if performance is important to you,
consider taking the time to run benchmarks with your application under
various configurations.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <hushdontspamme@.hotmail.com> wrote in message
news:eU68yba9FHA.1148@.tk2msftngp13.phx.gbl...
> Hi
> Has anyone had any SQL performance issues when Hyper Threading is enabled
> on BIOS? Do you have any comments regarding to HT?
> I know this is a bit of a grey area for Citrix - but i have not seen any
> comments about this for SQL
> Regards
> James
>
|||Have a look here:
http://blogs.msdn.com/slavao/archive...12/492119.aspx
Markus
|||<Excerpt>
So does it mean you have to disable HT when using SQL Server? The answer is
it really depends on the load and hardware you are using.
You have to test your application with HT on and off under heavy loads to
understand HT's implications.
</Excerpt>
There is no substitute for thorough performance testing when you have a
demanding application and/or expect to tax the hardware. I ran a benchmark
with our app on a 4-way (8 logical) proc server and we got 15-20% percent
improvement with HT enabled at the bios level. It would have been a pity to
throw this away.
Hope this helps.
Dan Guzman
SQL Server MVP
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133359063.147112.317730@.z14g2000cwz.googlegr oups.com...
> Have a look here:
> http://blogs.msdn.com/slavao/archive...12/492119.aspx
> Markus
>
|||Hi
Hi I wonder which tools (benchmarks) are you using to get the
performace infomation.
Thanks
Yoel
Dan Guzman wrote:
> <Excerpt>
> So does it mean you have to disable HT when using SQL Server? The answer is
> it really depends on the load and hardware you are using.
> You have to test your application with HT on and off under heavy loads to
> understand HT's implications.
> </Excerpt>
> There is no substitute for thorough performance testing when you have a
> demanding application and/or expect to tax the hardware. I ran a benchmark
> with our app on a 4-way (8 logical) proc server and we got 15-20% percent
> improvement with HT enabled at the bios level. It would have been a pity to
> throw this away.
>
|||I performed a controlled test using our production application code and
data. The performance I reported was based on the actual elapsed time
difference. IMHO, this is the most meaningful type of test since the
objective is to optimize the server for production application processing.
Importantly, the application I tested was typical OLTP and highly optimized
with very few scans. Results could be different with an OLAP/reporting
application profile, a different OLTP application or different application
mix. I mentioned this when I posted to Slava's blog.
It can take considerable work to develop and run application benchmarks like
this. Such effort can be justified when you have demanding mission critical
applications that will fully tax your hardware but perhaps not justified
when hardware resources are less utilized. In my case, performance testing
and tuning was required anyway so that we could perform an application
migration in the shortest possible time.
Hope this helps.
Dan Guzman
SQL Server MVP
"Yoel Zumbado" <yzumbado@.hotmail.com> wrote in message
news:OK8Cfe0AGHA.3984@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hi
> Hi I wonder which tools (benchmarks) are you using to get the performace
> infomation.
> Thanks
> Yoel
> Dan Guzman wrote:

Intel Hyper Threading

Hi
Has anyone had any SQL performance issues when Hyper Threading is enabled on
BIOS? Do you have any comments regarding to HT?
I know this is a bit of a grey area for Citrix - but i have not seen any
comments about this for SQL
Regards
JamesOn our SQL boxes, we keep HT enabled and tweak the SQL Server max degree of
parallelism config option to specify no more than the number of processor
cores.
Every application is different so, if performance is important to you,
consider taking the time to run benchmarks with your application under
various configurations.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <hushdontspamme@.hotmail.com> wrote in message
news:eU68yba9FHA.1148@.tk2msftngp13.phx.gbl...
> Hi
> Has anyone had any SQL performance issues when Hyper Threading is enabled
> on BIOS? Do you have any comments regarding to HT?
> I know this is a bit of a grey area for Citrix - but i have not seen any
> comments about this for SQL
> Regards
> James
>|||Have a look here:
http://blogs.msdn.com/slavao/archiv.../12/492119.aspx
Markus|||<Excerpt>
So does it mean you have to disable HT when using SQL Server? The answer is
it really depends on the load and hardware you are using.
You have to test your application with HT on and off under heavy loads to
understand HT's implications.
</Excerpt>
There is no substitute for thorough performance testing when you have a
demanding application and/or expect to tax the hardware. I ran a benchmark
with our app on a 4-way (8 logical) proc server and we got 15-20% percent
improvement with HT enabled at the bios level. It would have been a pity to
throw this away.
Hope this helps.
Dan Guzman
SQL Server MVP
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133359063.147112.317730@.z14g2000cwz.googlegroups.com...
> Have a look here:
> http://blogs.msdn.com/slavao/archiv.../12/492119.aspx
> Markus
>|||Hi
Hi I wonder which tools (benchmarks) are you using to get the
performace infomation.
Thanks
Yoel
Dan Guzman wrote:
> <Excerpt>
> So does it mean you have to disable HT when using SQL Server? The answer i
s
> it really depends on the load and hardware you are using.
> You have to test your application with HT on and off under heavy loads to
> understand HT's implications.
> </Excerpt>
> There is no substitute for thorough performance testing when you have a
> demanding application and/or expect to tax the hardware. I ran a benchmar
k
> with our app on a 4-way (8 logical) proc server and we got 15-20% percent
> improvement with HT enabled at the bios level. It would have been a pity
to
> throw this away.
>|||I performed a controlled test using our production application code and
data. The performance I reported was based on the actual elapsed time
difference. IMHO, this is the most meaningful type of test since the
objective is to optimize the server for production application processing.
Importantly, the application I tested was typical OLTP and highly optimized
with very few scans. Results could be different with an OLAP/reporting
application profile, a different OLTP application or different application
mix. I mentioned this when I posted to Slava's blog.
It can take considerable work to develop and run application benchmarks like
this. Such effort can be justified when you have demanding mission critical
applications that will fully tax your hardware but perhaps not justified
when hardware resources are less utilized. In my case, performance testing
and tuning was required anyway so that we could perform an application
migration in the shortest possible time.
Hope this helps.
Dan Guzman
SQL Server MVP
"Yoel Zumbado" <yzumbado@.hotmail.com> wrote in message
news:OK8Cfe0AGHA.3984@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hi
> Hi I wonder which tools (benchmarks) are you using to get the performace
> infomation.
> Thanks
> Yoel
> Dan Guzman wrote:

Intel Hyper Threading

Hi
Has anyone had any SQL performance issues when Hyper Threading is enabled on
BIOS? Do you have any comments regarding to HT?
I know this is a bit of a grey area for Citrix - but i have not seen any
comments about this for SQL
Regards
JamesOn our SQL boxes, we keep HT enabled and tweak the SQL Server max degree of
parallelism config option to specify no more than the number of processor
cores.
Every application is different so, if performance is important to you,
consider taking the time to run benchmarks with your application under
various configurations.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <hushdontspamme@.hotmail.com> wrote in message
news:eU68yba9FHA.1148@.tk2msftngp13.phx.gbl...
> Hi
> Has anyone had any SQL performance issues when Hyper Threading is enabled
> on BIOS? Do you have any comments regarding to HT?
> I know this is a bit of a grey area for Citrix - but i have not seen any
> comments about this for SQL
> Regards
> James
>|||Have a look here:
http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx
Markus|||<Excerpt>
So does it mean you have to disable HT when using SQL Server? The answer is
it really depends on the load and hardware you are using.
You have to test your application with HT on and off under heavy loads to
understand HT's implications.
</Excerpt>
There is no substitute for thorough performance testing when you have a
demanding application and/or expect to tax the hardware. I ran a benchmark
with our app on a 4-way (8 logical) proc server and we got 15-20% percent
improvement with HT enabled at the bios level. It would have been a pity to
throw this away.
Hope this helps.
Dan Guzman
SQL Server MVP
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133359063.147112.317730@.z14g2000cwz.googlegroups.com...
> Have a look here:
> http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx
> Markus
>|||Hi
Hi I wonder which tools (benchmarks) are you using to get the
performace infomation.
Thanks
Yoel
Dan Guzman wrote:
> <Excerpt>
> So does it mean you have to disable HT when using SQL Server? The answer is
> it really depends on the load and hardware you are using.
> You have to test your application with HT on and off under heavy loads to
> understand HT's implications.
> </Excerpt>
> There is no substitute for thorough performance testing when you have a
> demanding application and/or expect to tax the hardware. I ran a benchmark
> with our app on a 4-way (8 logical) proc server and we got 15-20% percent
> improvement with HT enabled at the bios level. It would have been a pity to
> throw this away.
>|||I performed a controlled test using our production application code and
data. The performance I reported was based on the actual elapsed time
difference. IMHO, this is the most meaningful type of test since the
objective is to optimize the server for production application processing.
Importantly, the application I tested was typical OLTP and highly optimized
with very few scans. Results could be different with an OLAP/reporting
application profile, a different OLTP application or different application
mix. I mentioned this when I posted to Slava's blog.
It can take considerable work to develop and run application benchmarks like
this. Such effort can be justified when you have demanding mission critical
applications that will fully tax your hardware but perhaps not justified
when hardware resources are less utilized. In my case, performance testing
and tuning was required anyway so that we could perform an application
migration in the shortest possible time.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Yoel Zumbado" <yzumbado@.hotmail.com> wrote in message
news:OK8Cfe0AGHA.3984@.TK2MSFTNGP14.phx.gbl...
> Hi
> Hi I wonder which tools (benchmarks) are you using to get the performace
> infomation.
> Thanks
> Yoel
> Dan Guzman wrote:
>> <Excerpt>
>> So does it mean you have to disable HT when using SQL Server? The answer
>> is it really depends on the load and hardware you are using.
>> You have to test your application with HT on and off under heavy loads to
>> understand HT's implications.
>> </Excerpt>
>> There is no substitute for thorough performance testing when you have a
>> demanding application and/or expect to tax the hardware. I ran a
>> benchmark with our app on a 4-way (8 logical) proc server and we got
>> 15-20% percent improvement with HT enabled at the bios level. It would
>> have been a pity to throw this away.

Integrity Constraints

I had a question regarding using XML as a database rather than a data format.
Can some/all types of integrity constraints that we (can) have in a SQL database be represented/mapped to XML?
Could anyone explain or give some pointers to this...
-Aayush
I'm not sure exactly what you're asking. In general, XML isn't a database
so using it as a database doesn't make sense. In the limited scope of the
topic of this newsgroups, SQL Server 2000 and SQLXML allow you to store the
data in an XML document as one or more rows of normal relational data.
Because the XML is mapped to relational data, the integrity constraint on
the relation data apply so for example you may not be able to insert a
document that has order lines if no corresponding order header exists. Note
that this is possible because XML is being shredded into relational data and
is not an inherent part of XML. In general, XML schemas don't support
defining or enforcing most integrity constraints.
Does this answer your question?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Aayush Puri" <anonymous@.discussions.microsoft.com> wrote in message
news:3EC02BEB-4AEA-438C-AB11-4D4F33C1CD6D@.microsoft.com...
>I had a question regarding using XML as a database rather than a data
>format.
> Can some/all types of integrity constraints that we (can) have in a SQL
> database be represented/mapped to XML?
> Could anyone explain or give some pointers to this...
>
> -Aayush
>
|||Hey,
Thankx for the reply. Yeah I know that it makes little sense to use XML as
a database rather than a data format...but the app. which I am trying to
design is for users *not* having any SQL database. I was just just wondering
if XSD allows me to specify constraints alike SQL or if possible things like
triggers etc...
U got my point right.
Thankx,
-Aayush

Friday, February 24, 2012

Integration Services Data Types

Hi, I have a question regarding the Integration Services Data Types.

From http://msdn2.microsoft.com/en-us/library/ms141036(d-printer).aspx, I found a table that shows me the Mapping of Integration Services Data Types to Database Data Types.

For example, how the DT_BOOL Data Type maps to bit for SQL Server.

In this case, I am okay, as I know exactly what the mapping is, however, for some of the datatypes, I do not.

Here is an example. The DT_CY datatype maps to smallmoney and money ... how do I know which one to map to? For me, which one I map to does indeed matter because their representation is different.

DT_NUMERIC maps to decimal and numeric ... this one does not matter as much

DT_STR/DT_WSTR ... I need to know whether its char, varchar, ncahr, or nvarchar for padding purposes mostly.

Any help would be gladly appreciated.
As for DT_CY, you pick. Either will work.

DT_STR = varchar, char
DT_WSTR = nvarchar, nchar|||From what I am doing with the values, I can not just pick for DT_CY. I need to know whether it is actually smallmoney, or money.

Same goes with DT_STR and varchar, char ... I need to know whether its one or the other.

And similarly for nvarchar/nchar for DT_WSTR.

I am passing these values to an application that needs to know what is what because it treats each value differently.

|||

theddern wrote:
From what I am doing with the values, I can not just pick for DT_CY. I need to know whether it is actually smallmoney, or money.
Same goes with DT_STR and varchar, char ... I need to know whether its one or the other.
And similarly for nvarchar/nchar for DT_WSTR.
I am passing these values to an application that needs to know what is what because it treats each value differently.

You are on the wrong end of the question though.

YOU have to decide which SQL Server data type best fits the data. SSIS doesn't dictate that; you do.

So yes, you have to pick and stick with it. Do you understand the differences in the SQL Server datatypes? You might not ever use char/nchar (retains trailing spaces) so that might solve that issue for you. DT_CY, well, you just need to know what the data supports and choose the correct one.|||Alright thanks

Friday, March 30, 2012

Internal Error / internal catalog exception

Internal Error / internal catalog exception

Friday, March 9, 2012

Intel Hyper Threading

Intel Hyper Threading

Intel Hyper Threading

Integrity Constraints

Friday, February 24, 2012

Integration Services Data Types

Integrated Security

Blog Archive

About Me