Ascii 582

Is there any possibility to set up srv collation in 852 manner (SQL 2000) ?
thx in advance pxal.SQLSERVER2K supports these code pages:
1258,1257,1256,1255,1254,1253,1252,1251,1250,950,9 49,936,932,874,850,437

Central European Windows - CP 1250
Central European DOS - Latin 2 (CP 852)

So CP 852 is not supported and advanced CP - COLLATIONS are used.

For example, for Czech language (Central European) use collations:
/* SQL collations */
SQL_Czech_CP1250_CI_AS
SQL_Czech_CP1250_CS_AS
/* Widows collations */
Czech_CS_AS
Czech_CS_AI
Czech_CI_AS
Czech_CI_AI
Czech_BIN
Suffixes _CS,_CI,_AS,_AI specify Case and Accent sensitivity.
You also can add suffixes _KS,_KI,_WS,_WI (Kana and Width sensitivity), but they are not used.
With suffix _BIN raw binary data are used, fast, but dangerous.

Then binary stored:
CP1250 (1 B) when char /varchar /text datatype is used
UNICODE (2 B) when nchar/nvarchar/ntext datatype is used

Collation affectes comparing (linking) and sorting data (grouping,indexes).
Use COLLATE translating option to change behavior of query.
select 'abcd' COLLATE Czech_CS_AS

See BOL for more.|||0. ACP on srv win2k:1250, OEMCP: 852 (clients: the same)
1. I'm runnig Polish_CI_AS on sql 2k (it ansi)
2. I have application via ODBC (so it is ANSI app) -> Latin 2 (1250) (more, internally it converts ascii (oem 852) to ansi 1250 before sending into srv via odbc)
1+2-> no translation AutoAnsiToOem is needed (if apply nothing should heppens: ansi to ansi)
3. finally there is 3rd party soft (MS Access) also via odbc -> also ansi, connected to to the same db.

so ascii codes runs like follows:
main app: sends ascii[168] (after internal converting into 1250 ascii[191]) - no translation of ascii[191]- srv stores ascii[191]
connecting with access: I see ascii[191]

the problem is I'm runnig all of them as ansii clients and server: so there is no translation; but main app used to translate from ansii 2 ascii herself.
so I thoght to install sql srv as oem in native mine cp 852 to force DB-Function: AutoAnsiToOem.

translating storage into unicode is not possible: more than 300 tbl's in dbd and app doesn't like it
thx in advance, pawel|||Try adding replace of ascii[191] by ascii[168] in trigger or application before insert/update.
What about "Perform translation for character data" check box in ODBC?

P.S. If your are completly rewritting your starting post, are you able to change its subject from ASCII 582 to ASCII 852?|||Try adding replace of ascii[191] by ascii[168] in trigger or application before insert/update.
>> it is not possible, I have no influence what app sends. I put that trig in SQL srv and I will work with "backup" table with required dataset format,.
I wanted to find "native" solution for sql srv but probably I failed.

What about "Perform translation for character data" check box in ODBC?
>> do not work
I heard about translation tables for cp's in Fox Pro ans Sybase ODBC connectors but I cannot find them.

P.S. If your are completly rewritting your starting post, are you able to change its subject from ASCII 582 to ASCII 852?
>> :) pardon I was sleepy and tired

thx anyway, Pawel

AS service hangs on cube build 'start'/ timeout on process cube

I apologize in advance for the duplication, I just found this forum and wanted to post my questions/concerns here. I had previously posted to the discussion group. If anyone has any advice, I would love to hear from you. We are struggling with performance issues, particularly with making changes to the cubes now that our warehouse has grown.

Thank you in advance,

~Shari

We have two apparent issues with Analysis Services (AS) as outlined below:

1. We have a rebuild of the nightly cube build and quite often the first step would hang (just run without processing).We would have to stop the job, restart Analysis Services and then start the job again, resulting in loss of processing time and an impact to our Production Reporting.As a workaround for this intermittent problem, we have adjusted the nightly job to include a stop and start of AS before the cube build begins.An outline of the current steps:

· net stop MSSQLServerOLAPService

· net start MSSQLServerOLAPService

· dtexec /DTS "\MSDB\SSAS_Full_Dim_Load_Prod" /SERVER serverName /MAXCONCURRENT " -1 " /CHECKPOINTING OFF/REPORTING V

· process cub files

· backup cube

We need to know why AS does not process cubes as it should from time to time.Do we have a configuration problem?Is our Production Server not sufficient enough for AS and the size of the cube?We have more than the minimum requirements but possibly we need more due to our expectation of the cubes and data.

Server Specifications à

Production

CPU = Quad 2.8 GHz Intel Xeon (Hyper-Threaded)

Memory = 20476 MB

OS – Windows 2003. SP1

SQL Server 2005

64 bit based on the x64 platform

2. We have been unable to deploy a copy of the Production cubes to a new server.We even tried deploying a smaller cube, to include a large dimension (ex: Account). We continually experience time outs with the larger dimensions.

a. Tried deploying from Visual Studio 2005

b. Attempted to Process the cube through SQL Server Management Studio

c. Attempted to Process the larger dimension only from SQL Server Management Studio

d. Attempted Parallel processing, Sequential – One Transaction, and Sequential – Separate Transaction.

e. Also tried changing the default timeout for the AS server.ForceCommitTimeout property was 30000, increased to 40000 and then again to 50000

f. Attempted to change the ExternalCommandTimeout property from 3600 to 7200. This was successful in the Disaster Recovery server which has nothing running (no users reporting).Although it did take over 5 hours to process.At that rate, it might take 2 days to rebuild the large cube that we have, with several partitions.

Disaster Recovery

CPU = Dual 3.00 GHz Intel Xeon MP (Hyper-Threaded)

Memory = 9728 MB

OS – Windows 2003 SP 1

SQL Server 2005

32bit

Errors -->

OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.

OLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00.

Re: 1

I've seen a scenario where the service "pauses" while processing due to threading issues. When that happens, issuing an unrelated query on another session while processing is stalled can cause the processing job to resume. If you're seeing that behavior, there are some tuning parameters that might help. They're not settings I'd encourage randomly tweaking, though, so I'll hold off on making any recommendations until I hear back.

Re: 2

There are a lot of possible variables here, and the investigation might need to ge tpretty involved. I'd really recommend opening a support ticket to try to resolve that one.

|||

Brad,

Thanks for your post. We have not seen that an unrelated query will trigger processing, per se. Basically once it hangs, it hangs until it is forced to stop. And unfortunately our cube jobs run for about 4-5 hours at night and what might appear to be "processing" is really a hang and it is not realized until we come in the next morning and see that it is not finished yet. The drag is that we lost a process of that cube. As I mentioned, we have put a stop and start of the AS service in the job as a safety but I we feel like we shouldn't have to do this and are more interested in getting the parameters tuned so that AS runs without incident.

As for the second issue, yes my next step is a case with MS. I thought I would post here and see if I could hear from others who may have experienced similiar first.

Thanks again,

Shari

|||

When you say it hangs, I assume you're seeing no CPU consumption or I/O, correct? Could you tell me what the query pool and processing pool busy and idle threads numbers are (under MSAS 2005: Threads in perfmon)?

Also, you say the CPUs support hyperthreading. Is HT actually enabled, such that it looks like 8 CPUs? I ask because it affects the size of the thread pools.

- Brad

AS actions available through RS in SQL 2005.

Hi, I'm looking for any documentation explaining how RS can use AS actions. Can someone please help me? Is it feasible?

Thanks in advance.

Reporting Services does not expose AS actions. This is on the list of features we may add in a future version.

-Albert

|||Thanks.|||

Note: you can still setup AS actions in the cube that trigger the execution of RS reports.

-- Robert