Layout for Parameters in Menu Bar

I want to change the layout for the parameters in my menu bar.
I understand that with SP1, I can use style sheets.
1.
I want to group three on top and then but a horizontal bar <hr>
and then I want to put four in the middle - and agin a <hr>
and then three at the bottom.
2.
Also - can I convert the drop down menu to a 'scrolling text box' solme how?
I attempted to edit the MyStyle... but with limited luck.
Any suggestion is appreciated.The customizations that SP1 adds will not let you make these changes. You
can, however, implement your own parameters area and hide the default one.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407211153.48c4e7e0@.posting.google.com...
> I want to change the layout for the parameters in my menu bar.
> I understand that with SP1, I can use style sheets.
> 1.
> I want to group three on top and then but a horizontal bar <hr>
> and then I want to put four in the middle - and agin a <hr>
> and then three at the bottom.
> 2.
> Also - can I convert the drop down menu to a 'scrolling text box' solme
how?
> I attempted to edit the MyStyle... but with limited luck.
> Any suggestion is appreciated.|||Implementing my own parameter area -
- Would SOAP be the preferred way to do that? (Besides URL calls)
- Can I use "Infopath" for making such SOAP calls and redisigning the
parameter forms?
Thxsql

Launch SQL 2005 Database Tuning Advisor

we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition
with SQL
05 SP1. try to launch Database Tuning Advisor from the Tools, then got
the
following error message box:
"Microsoft Visual C++ Runtime Library
Runtime Error
R6031 - Attempt to initialize the CRT more than once. This indicates a
bug
in your application"
Find out KB 913395, however there is no "Explorer.exe process" under
HKEY_CURRENT_USER\Software\Microsoft\WindowsNT\CurrentVersion\AppCompatFlags\Layers,
all I have are:
1. Default
2. D:\en_sql_2005_ent_x64_sp1\en_sql_server_sp1_x64.exe
Please advise.
ThanksPlease see the following mail thread
http://groups.google.com/group/microsoft.public.sqlserver.tools/browse_frm/thread/b6160e7593b8dda0/052524332db36557?lnk=st&q=%22database+engine+tuning+advisor%22&rnum=2&hl=en#052524332db36557
Sidenote:Unfortunately this really is an Appcompat issue and has
nothing to do with DTA, that is, this bug can be reproed using any
process
Manoj
Don wrote:
> we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition
> with SQL
> 05 SP1. try to launch Database Tuning Advisor from the Tools, then got
> the
> following error message box:
> "Microsoft Visual C++ Runtime Library
> Runtime Error
> R6031 - Attempt to initialize the CRT more than once. This indicates a
> bug
> in your application"
> Find out KB 913395, however there is no "Explorer.exe process" under
> HKEY_CURRENT_USER\Software\Microsoft\WindowsNT\CurrentVersion\AppCompatFlags\Layers,
>
> all I have are:
> 1. Default
> 2. D:\en_sql_2005_ent_x64_sp1\en_sql_server_sp1_x64.exe
> Please advise.
> Thanks

Launch SQL 2005 Database Tuning Advisor

we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition
with SQL
05 SP1. try to launch Database Tuning Advisor from the Tools, then got
the
following error message box:
"Microsoft Visual C++ Runtime Library
Runtime Error
R6031 - Attempt to initialize the CRT more than once. This indicates a
bug
in your application"
Find out KB 913395, however there is no "Explorer.exe process" under
HKEY_CURRENT_USER\Software\Microsoft\Win
dowsNT\CurrentVersion\AppCompatFlags
\Layers,
all I have are:
1. Default
2. D:\en_sql_2005_ent_x64_sp1\en_sql_server
_sp1_x64.exe
Please advise.
ThanksPlease see the following mail thread
http://groups.google.com/group/micr...52524332db36557
Sidenote:Unfortunately this really is an Appcompat issue and has
nothing to do with DTA, that is, this bug can be reproed using any
process
Manoj
Don wrote:
> we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition
> with SQL
> 05 SP1. try to launch Database Tuning Advisor from the Tools, then got
> the
> following error message box:
> "Microsoft Visual C++ Runtime Library
> Runtime Error
> R6031 - Attempt to initialize the CRT more than once. This indicates a
> bug
> in your application"
> Find out KB 913395, however there is no "Explorer.exe process" under
> HKEY_CURRENT_USER\Software\Microsoft\Win
dowsNT\CurrentVersion\AppCompatFla
gs\Layers,
>
> all I have are:
> 1. Default
> 2. D:\en_sql_2005_ent_x64_sp1\en_sql_server
_sp1_x64.exe
> Please advise.
> Thanks

LastNonEmpty and AverageOfChildren

Hello,

we are using SQL 2005 with SP1 and we have quite small cube (<1GB).

We have a couple of measures with aggregate function AverageOfChildren or LastNonEmpty.

End users have very poor performances while browsing cube using these measures.

When we replace agg. function with SUM, for example, performances become normal.

I saw simillar discusion on OLAP forum, but I did not understand what is the best recommendation for this situation?

Is this known issue, and how it can be avoided?

Best regards

Borko

Borko,

What's your aggregation strategy for this measure group? Queries to semi-additive measures are resolved by initially going down to granularity for the measure group's time dimension and subsequently computing the aggregate. Because of this, it's important to insure that you have an aggregation that includes the granularity attribute. If not already there, you can generally force the attribute to be included by setting the AggregationUsage property to "Full" in the cube editor. However, since this setting applies across all measure groups, you may want to set it, design aggregations for this measure group, and then rest the value.

I'm not positive that this will solve your issue, but this is where I would start.

-rob

Large table hogging cache

Using SQL Server 2000, SP1 with 4Gb max memory allocated to the instance. The problem is that one large table is hogging cache and it's dragging down overall query performance. I realise it's in cache because it's getting queried regulary. However, I need to know what options exist to get around this problem - to free up some cache for other tables and indexes? Of course, there is the option of archiving off some the data in the table to reduce its size and we will look at doing this although it will not be as easy as it sounds.

I can imagine that there must be many databases that have at least one large table that is getting hit regularly and is left in cache more-or-less permanently. Therefore, I can't believe I have an usual problem.

Thanks in advance,
ZartyHi Zarty

Are you sure it is this the caching of this table causing performance problems and nothing else? Have you read up on the lazy writer and understand how it decides what to keep in cache and what to release (in particular how it calculates cost)?

My point is - if this table is queried regularly and SQL Server determines that it is best left in the cache - why would you want to force SQL Server to retrieve the data from the disk each and every time the table is queried? Wouldn't you expect this to cause the performance to dramatically decrease?

Anyway - I don't know how to clear a single table from the cache or if it is possible. Best I have is a decent article about the cache:
http://www.sql-server-performance.com/rd_data_cache.asp|||I'm not sure about a lot of things! I just find it very difficult to get definite info on what SQL Server is doing/reporting in some areas. For example, in Perfmon, the Page Life Expectancy counter... I would assume that seeing this counter dip to zero regularly and struggle to get above 200 seconds would be a bad thing? If so, I have a problem. However, at the same time, I see Buffer Cache Hit Ratio look healthy at 99% +. I can't reconcile these two pieces of information.

Another example... In the article you suggested (http://www.sql-server-performance.com/rd_data_cache.asp), it mentions syscacheobjects and BOL confirms that 'user tables' are a possible object type. Therefore, I am confused when I query syscachetables and do not see hardly any references to user tables at all on the system in question (on other sql instances I do) and certainly no reference to the large and regularly quiried tables in question. However, if I analyse the output from DBCC MEMUSAGE, I can definitely see regularly queried user tables reported as being in cache as one would expect. Can you see why I find it so difficult to get a full picture of what is going on?

What I can say is that I've focused mainly on the info reported by DBCC MEMUSAGE and, from that, we've identified some large user tables that are hogging cache and we have evidence through Page Life Expectancy and other sources that many other important tables don't get much cache time. I get the impression that SQL Server is busy thrashing pages in and out of cache and it would be better if it could leave a bigger proportion of them there. I've also seen that better indexing on a table can improve the problem a lot. SQL Server seems to cache a lot less of a user table if the indexing is sorted out. So, in some ways, things are improving here. However, as soon as we improve the situation for one table, the cache space made available seems to be quickly taken up and hogged by another large table. We're chipping away at the indexing but it's not always possible/practical to create much of a cache space saving through improved indexing.

What I've tried to explain here is that if it were just a problem of one table staying in cache, you're right, it wouldn't be a problem... However, that is not the problem. The problem is that a few tables appear to fill most of the available cache and there is a lot of other important table data that doesn't seem to get much cache time because the cache appears relatively small and doesn't grow despite the fact that a bigger memory pool has been assigned to SQL Server via the Max Memory setting. I'm going for a service restart this weekend by the way.

Thanks,
Zarty